Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.charting
|
|||
|
|||
Q: Including subtotals in a pivot chart
Hello All:
I am presenting rolling 13 weeks of data on various manufacturing problemin our operations with a pivot chart. On the chart I would like to show the subtotals for each problem as well but I cannot figure out a way of doing this. Any suggestions? Thanks! Deguza ----------------------------------- Sample pivot chart --------------------------------------- Sum of Qty Product Problem Week Total Blue_gadget Assembly error 2007 12 2007 14 2007 13 2007 15 2007 16 18 2007 17 4 2007 19 2007 20 6 2007 18 10 2007 21 2007 22 2007 23 2007 24 Assembly error Total 38 [...] Damaged part 2007 12 2007 14 2007 13 2007 15 2007 16 2007 17 2007 19 2007 20 13 2007 18 2007 21 2007 22 2007 23 2007 24 Damaged part Total 13 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL | Excel Discussion (Misc queries) | |||
Subtotals including blank rows | Excel Discussion (Misc queries) | |||
Copy Excel Chart (including drawn objects) into Word | Charts and Charting in Excel | |||
making a chart including only the top 20 (or 10, or whatever) | Excel Discussion (Misc queries) | |||
Not including blank fields in pivot tables | Excel Worksheet Functions |