Pie Charts - Multiple Series
Posted by wpd on March 06, 2001 12:32 PM
I want to plot a pie chart that shows three categories of audits, the number of audits performed in each category, and the average rating percentage for the number of audits within each category. For example, Audit category A had 20 audits performed with an average rating of 70%, category B had 30 audits performed with an average of 80% and category C had 40 audits performed with an average rating of 90%.
How can I get the pie to show both the count of audits for each piece (audit category) AND the average results? I can't use the "%" feature of the data labels in excel - that just shows the relative percentage of each piece of the pit to the overall pie.