asked on

Access vs. Excel Charts

I am using Access 2007 for marketing presentations but the charts are very primitive. I can not even reposition the labels. Excel on the other hand has fantastic usability. The charts are very good looking and much more customizable. Is there a way to do this with Access? Maybe add-ons or 3rd party charting software? If possible can you use Excel for the charts but use Access for data collection? Access 2010 is no different btw. Thank you

SOLUTION

tbsgadi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeffrey Coachman

Moving a Label in an Access chart
untitled.JPG

napsternova

ASKER

Thanks for the help,
tbsgadi, have you tried this software? I would like to see an example of it in action. I think I will try contacting them as well.

boaq2000, well I was designing these as pivotcharts but this way will have to do. I sent Microsoft an email asking about making the charts more graphically appealing.

Jeffrey Coachman

<I was designing these as pivotcharts
I don't think you mentioned that in your original question...
You just said "Charts"

While you can certainly "Link" you Access data into Excel and create a Stunning Chart, this can end up being awkward.

For this reason, give tbsgadi link a good try.

;-)

JeffCoachman