Show values & percentages in a pie chart?

[cmwebster86]

Hello!

I am trying to get my pie chart to show the actual values and the % to total for each 'slice'... Is there any easy way to display both of these metrics?
Thanks!

 

[cyrilbrd]

What version of excel are you using?
Add labels, select labels, select format data labels, go to labels options, tick both Value and Percentage, use the separator of your liking.
Would that work for you?

 

[whywhy73]

What version of excel are you using?
Add labels, select labels, select format data labels, go to labels options, tick both Value and Percentage, use the separator of your liking.
Would that work for you?

How about if I want to show both the value but the percentage is in bracket for example 1500 (5%)?
Is it possible to have such combination and with data in the pie chart updated automatically if the table cell updated?
I know the data format in the pie chart can be changed manually but can't be updated automatically after u change the format.

Thanks
!

 

[cyrilbrd]

Hi, What version of excel are you using?

 

[whywhy73]

Hi, What version of excel are you using?

Excel 2010