Recommended way to include a pie chart and table in a report

Posted on 2011-05-08
Last Modified: 2013-11-29
I have been asked to prepare a report from a MS Access database that takes data from the database and include a table and pie chart from an external source and I am seeking suggestions on the best way to handle it.

The table data comes from a government web site where I can enter my parameters (suburb) and generate the table. The web page generates a one line header followed by a table with 14 rows and 7 columns, perferctly formatted. It is easy to copy the entire page, paste it into a spreadsheet and then I just select the first row (headings) and last row  (12 month totals) to generate a pie chart. I then explode one slice of the pie chart, rotate the pie so that my exploded slice is in the right position and it's ready to use.

Once I have generated the table and pie chart (which covers an entire suburb) I want to keep it so that I can use it for any ad-hoc reports generated for other customers who come from that suburb. The table data only needs to be updated every 12 months or so.

The way I see it I can:
1) try to save the data in the MS Access database and try to get MS to generate the Pie Chart, thought I don't think MS Access 2007 is particularly good at generating pie charts; or
2) I could save the table data and pie chart in a workbook and then write some VBA in my database to open the workbook, search for the required spreadsheet, then somehow copy that data table and chart into the report; or
3) save the data table and chart as images on the computer hard disk and then include a hyperlink to those images in a suburb data base and include those images in my report.

In this question I am not asking HOW to do it - I will ask separate questions if required later - I just want to know what you think would be the best way to approach the project - one of the above 3 options or some other option.
Question by:Rob4077
    LVL 84

    Accepted Solution

    Many use an embedded Excel object to work with pie charts. If your data only changes every 12 months or so, however, you might be better off (performane-wise, anyway) to generate the report and export it as an image (a pdf or something of that nature), and include a link to that item from your Access app.

    Author Comment

    Thanks for your suggestion. It was the way I thought I should go.

    However between the time I posted the question and the time I got your response I played around and developed a way to take the table data out of the clipboard into an Access table and then I created a report which included the exploded pie chart I needed (in MS Access format). The pie chart is not quite as good as the MS Excel version (because I cant rotate it) but I think it's good enough for what I want to achieve.

    On giving it further thought I am starting to think that what I really need to do is actually put it into a Word document rather than a report so that the user can fine tune the finished product if necessary. Tha't probably going to require another question to EE.

    Thanks again for your comment. It helped me confirm that my thinking was not a silly solution.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    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 …

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now