ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie in Pie Chart (https://www.excelbanter.com/charts-charting-excel/147469-pie-pie-chart.html)

Michael

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




Jon Peltier

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







All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com