View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 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