ExcelBanter - Pie charts - showing % & values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pie charts - showing % & values (https://www.excelbanter.com/excel-worksheet-functions/237671-pie-charts-showing-%25-values.html)

Lou H[_2_]

Pie charts - showing % & values

HI - Need help in plotting both % and absolute value in pie chart. I need
this to be automated - does somebody have a solution?

Luke M

Pie charts - showing % & values

Right click on pie chart, Chart options. On the Data Labels tab, select both
Value and Percentage. Select separator, if desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Lou H" wrote:

HI - Need help in plotting both % and absolute value in pie chart. I need
this to be automated - does somebody have a solution?

All times are GMT +1. The time now is 05:29 PM.