Access do pie charts, graphs, etc. like Excel?

Looking for a "can it be done?" answer, not really how to do it at this point. I have a complicated Excel Workbook that feeds a report (lots of graphs). I am moderately confident with Excel, but a beginner with Access. I have Access 2007 and just started reading "How to" books.  My question is, does Access have an easy way to produce a report with lots of graphs, pie charts etc as Excel?  For the collection of data, Access would work much better for me, but I am affraid I will lose the "Visual Picture / Overview" that everyone has come to love.
daniellyonsAsked:
Who is Participating?
 
rgautierCommented:
Yes, when designing reports in Access 2007, you can include a variety of graphs and pie charts, and they're very easy to just cut and paste right into the report designer.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
A way=Yes, An easy way=No.

You would be doing it using VBA code within the Microsoft Graph/Excel Object Models, which is a bear to code.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
My recommendation ... a 'real' chart app for this:

http://www.softwarefx.com/SfxNetProducts/ChartFX/

I've used it and it is AWESOME>

mx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
rgautierCommented:
I don't know why others feel that it isn't easy.  When you open up a Report or Form, in the Controls ribbon there is a 'Graph' object - and it comes in Wizard form.  It was very easy to choose the fields of the data that I wanted and it drew the graph and added labels and titles.  
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Yes, when designing reports in Access 2007, you can include a variety of graphs and pie charts,
Hmm, this would be the first legitimate reason I've heard for upgrading to 2007.  I must investigate this.
0
 
daniellyonsAuthor Commented:
Thanks all

Dan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.