Pie Chart with Value & Percent (Excel 2000)

Topic

New Reply

Hi All … besides adding a text box for manually adding either the value or the percentage–is there an automatic way for Excel to label the pie regions with BOTH the value and the percent?
Thanks
–cat

Reply | Quote

Replies

Here is one simple workaround (if you don’t display the labels):
Format Data series – data labels choose Labels and percent. Then add the VALUES to the labels for the regions

Steve

Reply | Quote