[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-08
Medium Priority
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 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 35715388
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

ID: 35717050
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.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

834 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