Pie of Pie

  • Thread starter Thread starter rekoop
  • Start date Start date
R

rekoop

In a Pie of Pie chart is it possible to show the
percentages in the smaller pie that make up one slice on
the main pie rather than a percentage of the whole.

i.e. if two equal values make up 100% of a slice that
takes up 50% of the whole I wish the smaller pie to show
two halves with a 50% label rather than 25%.


Thank-you
 
You can calculate the percentages in the worksheet, then use a utility like Rob
Bovey's Chart Labeler (http://appspro.com) or John Walkenbach's Chart Tools
(http://j-walk.com) to add the cell contents to the series as data labels. Both are
free, easy to install, and easy to use.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top