Re: How can I split slices of my pie chart into pieces?

  • Thread starter Thread starter Tushar Mehta
  • Start date Start date
T

Tushar Mehta

Using built in XL capability, you can do this with only one slice.
Select the pie-in-pie subtype of a pie chart. Note that the original
data must contain the individual components. So, in your example,
slice1-size
slice2-size
3.5
0.2
0.2
0.1

Then, double-click the pie chart and from the Options tab set the
appropriate 'Second plot contains the last __ values'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Alternatively, you could make the pie with smaller wedges, but format the 3.5, 0.2, 0.2, and 0.1
wedges in the same color. Then make a copy with them colored differently.

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