Pie of Pie

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
 
J

Jon Peltier

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/
_______
 

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 of Pie Chart type with smaller pie showing slices of main slic 1
Excel Can a pie of pie chart use animation/transitions? 1
Auto positioning of labels outside pie slices 2
Can I make a pie chart where the slices are also graphical? 4
How can I reset the default pie chart label "Other" to "Equity"? 1
Use different colors to show compoents of a pie slice 1
Normalize the second pie in a pie of pie chart 1
Pie Chart Options 1

Top