How to show total in pie chart (Excel 2000)
 

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 to show total in pie chart (Excel 2000)
 

In article ,
says...
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/ti...%20textbox.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

How to show total in pie chart (Excel 2000)
 

That works. Thanks so much for the advice!

"Tushar Mehta" wrote:

In article ,
says...
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/ti...%20textbox.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

How to show total in pie chart (Excel 2000)
 

You are welcome.

--
Regards,

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

In article ,
says...
That works. Thanks so much for the advice!

{snip}