Problem with % Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie Chart Labels 1
Excel Can a pie of pie chart use animation/transitions? 1
Hide items w/a 0 value in a chart? 1
Pie of Pie 5
Show Total In a Text Box in a Pie Chart 2
Why won't the charts update? 2
Excel Charts 1
Percentages in pie chart 4

Back
Top