Display Second Data Set in a PieChart

[kchen]

Hello,

I want to display all the following data into one pie chart. So far, I can easily make the pie chart (with only "Fruit and #") out of the data with vba, however I do not know how to (manually or by vba) add the "Avg Quality" number onto a data label.

Secondly, I would like to add the # and the percentage of a particular fruit to the pie chart.

Any ideas are greatly appreciated!

[kchen]

Since posting, I've looked at quite a few websites that definitively say, "Pie charts cannot display two sets of data".

For clarification, I have created a pie chart that displays the # of fruits in each category. What I want to add is a data label that also shows the "Avg Quality".

Thanks for reading...and any ideas?

[Andy Pope]

Those sites are wrong.
You can show 2 sets, although I would not recommend it.
http://www.andypope.info/charts/pies.htm

In your case it is simple a labeling issue. Why not incorporate the average number into the category label?

Post example workbook of what you currently have.

[kchen]

Hi Andy,

I have been trying to do just that. I can't find website/code information to incorporate "avg quality" into the data label.

Here's the workbook.

[Andy Pope]

This formula in D2 and copied down.

=A2& CHAR(10) & " (avg. " & C2 & ")"

[kchen]

Thanks again andy!