How to show total in pie chart (Excel 2000)

[RubyTue]

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

 

[Tushar Mehta]

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

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

 

[RubyTue]

That works. Thanks so much for the advice!

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

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

 

[Tushar Mehta]

You are welcome.

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

{snip}