MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Help?


Posted by Mark W. on March 06, 2001 12:41 PM

See 11447.html
and its followup

Posted by wpd on March 07, 2001 12:56 PM

Hey Mark W - great workaround. I can use this
in other applications. Do you know a way to
show an independent variable at the same spot as
the data value instead of off in the legend?

My Case is:

{"Audits","Count","Avg Score"
Type 1,40,78%
Type 2,60,88%
Type 3,50,65%}

The percentage shown is not relative to the
count of each type to the whole. What would look
best is if the data value displayed adjacent to
the pie piece would be "40 (78%)" rather than off
to the edge in the legend. Possible? If not,
your solution works.

Posted by Mark W. on March 07, 2001 1:58 PM

> What would look best is if the data value
> displayed adjacent to the pie piece would be
> "40 (78%)" rather than off to the edge in the
> legend. Possible?

Now, I'm confused... my "workaround" shouldn't
have affected the legend. Didn't you display
and then modify the Data label for each pie
slice?

Posted by wpd on March 15, 2001 6:20 PM

Thank you Mark...I misunderstood your solution
the first time. I put the reference to your
formula in the "category labels" field in the
the soure data dialog instead of clicking
on the data label itself in the chart.

This solution works great.

I've been watching your work...you do this very
well.

wpd