Pie chart

[Julie]

Good day everybody,

I hope someone can help me and my colleague.

We are trying to do a pie chart.
A pie chart allows data label option of :
* none
* Show value
* Show percent
* Show label
* Show label and percent

But we would like to show pie charts with the following
option :
1. label, value and percent
2. value and percent

Is both possible?

Thank you in advance and have a nice day.

Best regards,
Julie

 

[Tushar Mehta]

Put whatever you want in a separate range of cells and use Rob Bovey's
free add-in, XY Chartlabeler, downloadable from www.appspro.com.

For example, suppose the labels are in A2:A5 and the values in B2:B5.
Then, in C2 enter =A2&", " & B2 &" ("&TEXT(B2/SUM($B$2:$B$5),"0.0%")
&")" Copy down to C3:C5.

Now, when using the add-in, specify C as the data labels range

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office

 

[Chaitanya]

I have another solution:

Your earlier data say is in this format.
label - value - Percent in three different columns.

Please change the data to the following format:

Label& value & percent in one column and value in another

Useing this, please create a pie chart and choose label
alone to be displayed.

Hope this work around will help you.

 

[Guest]

Thank you Tushar Mehta, Thank you Chaitanya,

I was hoping that Excel has a direct solution so that I don't have to workaround it.
But, at least we still can get the result that we want.

Thank you and have a nice day.

Best regards,
Julie