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 |
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