Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
Excel 2000: sum function automated? | Excel Discussion (Misc queries) | |||
How do I get the date correct in excel 2000 on a chart? | Charts and Charting in Excel | |||
Fan charts | Charts and Charting in Excel | |||
Pivot Table "Show All" Check Box missing in Excel 2000 | Excel Worksheet Functions |