If you have your data in columns, set up another column that concatenates the labelOn 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?
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
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.