Labels in Pic Charts

nevillestoke

Active Member
Joined
Mar 6, 2002
Messages
252
I would like to show the label name, value and percentage on my pie chart, but I can only use either label name and percentage or value. Is there any way around this?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
On 2002-03-07 11:02, nevillestoke wrote:
I would like to show the label name, value and percentage on my pie chart, but I can only use either label name and percentage or value. Is there any way around this?

If you have your data in columns, set up another column that concatenates the label
and value. If A1:A3 have the labels and B1:B3 have the values, make the formula
in C1=A1&CHAR(13)&B1 , etc. (CHAR(13) adds a carriage return: it will look right in the
chart.)

Now, right-click in the chart and select Source Data. Change the category labels
from the default to the new labels you have created (here, C1:C3). Also, make sure that
Chart Options shows "label and percent."

That should do it.
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top