If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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} |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart not printing on plotter Excel 2000 | Chris wongman | General Discussion | 0 | June 14th, 2005 10:52 AM |
Excel 2002 and 2000 co-install. Control Which Starts ? | cnuk | General Discussion | 2 | January 17th, 2005 08:07 PM |
Excel 2000 Line Chart Problem...HELP !!!! | Tushar Mehta | Charts and Charting | 2 | May 13th, 2004 12:12 AM |
Pivot Table "Show All" Check Box missing in Excel 2000 | Worksheet Functions | 2 | May 7th, 2004 03:45 PM | |
Problems creating Line-Column chart (Excel 2000) | Trell | Charts and Charting | 1 | April 17th, 2004 12:33 PM |