INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to properly link Excel Chart to Access Report?

How to properly link Excel Chart to Access Report?

(OP)
I am exporting data to an Excel spreadsheet, which creates a couple of charts that I need to link to an Access report. There are a couple of worksheets each containing several charts.

1) when I create an unbound object box and link the spreadsheet file to it, it only picks up part of the first chart and it looks bitmap-ish and terrible.

2) how do I link the second, third, etc. charts? to the report?

3) tried copy/past special/paste link/microsoft excel 2003 worksheet - which works - but it shows up like a bitmap instead of a smooth-looking graphic. If I do this in a Word doc, it looks beautiful. In an Access report, it looks amateurish and won't fly by management.

Is Access not able to embed or link Excel charts in a professional-looking manner?

What's the secret?

RE: How to properly link Excel Chart to Access Report?

I haven't attempted to link an Excel chart into an Access report. Is the a reason why you don't use Access charts?

Duane
Hook'D on Access
MS Access MVP

RE: How to properly link Excel Chart to Access Report?

(OP)
I don't use Access to chart because the end result looks like a first grader with brightly colored markers had at it. I need to use 3-D type objects like the 21st Century pie chart. The problem is that the shadows and depth show up as dots, and lines and colors are distorted. Very cartoonish.

RE: How to properly link Excel Chart to Access Report?

I guess I'm not about flashy charts. I like to keep it simple and direct without distracting formatting that doesn't generally add to the information.

Duane
Hook'D on Access
MS Access MVP

RE: How to properly link Excel Chart to Access Report?

(OP)
I don't have that luxury. Management wants what it wants and I have to figure out how to supply it.

RE: How to properly link Excel Chart to Access Report?

Hi,

Why does it have to be presented or generated in MS Access?

You already state, "I am exporting data to an Excel spreadsheet..."

You could do the entire process from Excel, calling the MS Access query to execute on command, if necessary and producing the requisite reports/charts.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close