Pie chart

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

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


In article ,
says...
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

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.



-----Original Message-----
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


In article ,
says...
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

.