Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie of pie charts - how to set up data
I'm just trying this kind of pie chart for the first time.
Example: I have 408 people in my company 401K. Of these, 38 joined in 2006, the other 370 joined in 2005. Of these 38 - 29 get company match, 9 don't. Is this the kind of info I can show in a pie of pie? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie of pie charts - how to set up data
Rich -
The 38 are combined in the main plot but shown as individual wedges in the secondary plot. Arrange the data like this: 2005 371 match 29 no match 9 Select the range and make the pie-of-pie chart. It initially only puts the no match data into the separate pie; double click on any of the wedges, and on the Options tab of the Format Series dialog, make sure these settings are selected: Split by: Position Second Plot Contains the Last: 2 values If you apply data labels to the chart, the merged match + no match wedge in the main chart has the label "other", which you can select and edit to say 2006". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "RichN" wrote in message ... I'm just trying this kind of pie chart for the first time. Example: I have 408 people in my company 401K. Of these, 38 joined in 2006, the other 370 joined in 2005. Of these 38 - 29 get company match, 9 don't. Is this the kind of info I can show in a pie of pie? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts - Align value & category data labels independently | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Charts don't update when data changes | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |