ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem with % Values (https://www.excelbanter.com/excel-discussion-misc-queries/36218-problem-%25-values.html)

Erin

Problem with % Values
 
In my excel pie chart I want to show percentage values that do not add up to
100. How do I stop Excel from automatically adjusting them? Thanks.

Anne Troy

Hi, Erin. A pie chart is only supposed to show 100% because that's... well,
that's what they're for. If you need to show some "unused" amount or
something, then include that in your data range.
*******************
~Anne Troy

www.OfficeArticles.com


"Erin" wrote in message
...
In my excel pie chart I want to show percentage values that do not add up

to
100. How do I stop Excel from automatically adjusting them? Thanks.





All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com