Pie / Pivot chart in Access report
Posted on 2011-09-02
I would like to create a Pie chart on my report which is going to show the progress of my Projects.
My database contains numerous projects and each has let‘s say 5 stages which carry certain number of % out of the total 100%. Let’s say that for project 1 first stage is over: through a form I would enter that the first stage is done, meaning that for example 15% of the project is realized (I connected % and stage-IDs, so this works fine). After a while the second stage will also be done, so now additional 20% is finished. This means in total 35% of the project is done, and this is what I want my pie to show: a full circle with 2 cut parts, each for the two stages.
When I make a report I group the stages on project level. Now when I insert the Pie chart it shows each stage on a separate pie, which is meaningless for my report.
I don’t know how to make the Pie show together all the stages which refer to the same Project.
Can I do this through simply entering the pie chart on report, or do I need to create a Pivot chart, and how?
Can anyone give me some advice?
Thank you all.