Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1415
  • Last Modified:

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.
0
daniellyons
Asked:
daniellyons
2 Solutions
 
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 MVP, Access and Data Platform)Commented:
My recommendation ... a 'real' chart app for this:

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

I've used it and it is AWESOME>

mx
0
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now