Solved

Access vs. Excel Charts

Posted on 2009-07-14
5
312 Views
Last Modified: 2013-11-28
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
0
Comment
Question by:napsternova
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 20 total points
ID: 24847774
Hi napsternova,

Have a look at the ChartExcel Wizard for MS Access
http://www.acc-technology.com/cewiz.htm


Good Luck!

Gary
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 105 total points
ID: 24848515
Access charts in Access 2007 can do the exact same things as Excel 2003 and older.
It is just harder to get to these options.

The only thing different in Access 2007 is that it does not have all the cool charting "effects"...
But again, basic chart manipulation is the same.

Open the Access chart in design View.
Right-Click on the chart.
Select: Chart Object-->Edit
This will put you in "edit mode"
In this mode, you can now right-Click on any Object and manipulate it in the same way as you can in Excel.

It takes a little practice and getting used to, but it is pretty straigntforward.
The key is staying in "Edit" mode.
It is easy to leave edit mode and not know it, because the screen looks the same.
(By clicking outside the chart/report)

But the Tollbar is different in Edit mode.
Here is a screenshot.

If you have any specific issues or question, feel free to post back here.

;-)

JeffCoachman
untitled.JPG
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24848533
Moving a Label in an Access chart
untitled.JPG
0
 

Author Comment

by:napsternova
ID: 24851293
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.  
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24851926
<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
0

Featured Post

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question