#1   Report Post  
Posted to microsoft.public.excel.charting
MLShef
 
Posts: n/a
Default Pie Charts

I have a list of data items which I want to put into a Pie Chart. Included
in this list are a number of statistics that are under $5,000 so it makes the
chart very messy. I would like to combine all stats under $5,000 into a
category that says "Clients < $5,000" - which I have done and is fine. But I
would like to further explode that pie piece to show the details. I just
can't seem to figure it out. Can someone help?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Pie Charts

This is the pie of pie chart type, the pie chart with a small satellite pie
off to the side. Choose this type in the Chart Wizard. when the chart is
finished you can double click on the pie, choose the options tab, and tell
it to split the series by value, so the second chart contains all values
less that 5000.

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


"MLShef" wrote in message
...
I have a list of data items which I want to put into a Pie Chart. Included
in this list are a number of statistics that are under $5,000 so it makes
the
chart very messy. I would like to combine all stats under $5,000 into a
category that says "Clients < $5,000" - which I have done and is fine.
But I
would like to further explode that pie piece to show the details. I just
can't seem to figure it out. Can someone help?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting worksheet with embedded charts FishMan Charts and Charting in Excel 2 October 5th 05 02:26 PM
Charts won't update pwermuth Charts and Charting in Excel 8 July 15th 05 07:32 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
linkingof charts in worksheets to cells steve Excel Discussion (Misc queries) 0 May 6th 05 01:44 AM
Can't create dynamic charts Brian Sells Charts and Charting in Excel 7 March 22nd 05 04:23 AM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"