How to show total in pie chart (Excel 2000)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm designing a "dashboard" and only want charts, not the raw data, but I
have been unable to show the total of all slices. I need to show the total
number of calls taken at the help desk and the % of the total for each type
(slice).

Thanks!
Ruby
 
I'm designing a "dashboard" and only want charts, not the raw data, but I
have been unable to show the total of all slices. I need to show the total
number of calls taken at the help desk and the % of the total for each type
(slice).

Thanks!
Ruby
Click to expand...
How about adding a textbox linked to a cell that contains whatever you want
to show? Something along the lines of the ideas at
Case Study =3F Incorporate worksheet information in a chart
http://www.tushar-mehta.com/excel/tips/0202-dynamic chart textbox.pdf
[Please note that the above URL is subject to change.]

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
That works. Thanks so much for the advice!

Tushar Mehta said:
I'm designing a "dashboard" and only want charts, not the raw data, but I
have been unable to show the total of all slices. I need to show the total
number of calls taken at the help desk and the % of the total for each type
(slice).

Thanks!
Ruby
Click to expand...
How about adding a textbox linked to a cell that contains whatever you want
to show? Something along the lines of the ideas at
Case Study =3F Incorporate worksheet information in a chart
http://www.tushar-mehta.com/excel/tips/0202-dynamic chart textbox.pdf
[Please note that the above URL is subject to change.]

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Click to expand...
 
Back
Top