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

Posted on 2007-10-18
Last Modified: 2013-11-28
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.
Question by:daniellyons
    LVL 65

    Expert Comment

    by:Jim Horn
    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.
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    My recommendation ... a 'real' chart app for this:

    I've used it and it is AWESOME>

    LVL 13

    Accepted Solution

    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.
    LVL 13

    Expert Comment

    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.  
    LVL 65

    Assisted Solution

    by:Jim Horn
    >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.

    Author Comment

    Thanks all


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now