custom number format

[ajm]

is it possible to use a custom number format in a pie chart to show the number required as a value, and also as a % of the Total. So, say you have 4 distinct elements to the pie chart. Values might be Element 1, 300, element 2, 100, element 3, 200, and element 4, 500. Grand total is 1100. Element 1 is 27%, Element 2 is 9%, Element 3 is 185, and Element 4 is 45%. How can I get the Label for each piece of pie, to be in the format "Element 1, 300, 27%"?

 

[Momentman]

On the Layout Tab, DATA LABEL options, you can tick "Category Name", "Value" and "Percentage" and you should have what you want

 

[ajm]

On the Layout Tab, DATA LABEL options, you can tick "Category Name", "Value" and "Percentage" and you should have what you want

ofcourse they do. Forgive me, its been a long week. I am actually using bar graphs not pie charts. Bar charts don't have this option. hence my search for a work around of some sort.