Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie in Pie Chart
Hi Folks - I have the following data:
Salaries 29% Programs 71% dept1 9% dept2 61% dept3 30% Dept1, 2 and 3 are part of salaries. I'd like to make a pie on pie chart that breaks out the salaries into the departments. Once I select the data and create the chart, I always get an extra slice in the primary chart name other. I'd like to eliminate other from the primary chart. Any ideas? Thanks. Michael |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie in Pie Chart
Other is the sum of the departmental salaries, right? So is Salaries. Make
the chart without the separate Salaries data point, and change the Other label to read Salaries. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Michael" wrote in message ... Hi Folks - I have the following data: Salaries 29% Programs 71% dept1 9% dept2 61% dept3 30% Dept1, 2 and 3 are part of salaries. I'd like to make a pie on pie chart that breaks out the salaries into the departments. Once I select the data and create the chart, I always get an extra slice in the primary chart name other. I'd like to eliminate other from the primary chart. Any ideas? Thanks. Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |