LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.charting
external usenet poster
 
Posts: 19
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXCEL COPY SUBTOTALS TO ANOTHER WORKSHEETWITHOUT INCLUDING DETAIL BobbyD Excel Discussion (Misc queries) 1 March 7th 07 09:59 PM
Subtotals including blank rows H0MELY Excel Discussion (Misc queries) 0 March 30th 06 08:11 PM
Copy Excel Chart (including drawn objects) into Word MarkN Charts and Charting in Excel 3 February 13th 06 02:09 PM
making a chart including only the top 20 (or 10, or whatever) ayla Excel Discussion (Misc queries) 0 December 6th 05 06:31 PM
Not including blank fields in pivot tables Bhupinder Rayat Excel Worksheet Functions 1 August 23rd 05 02:58 PM


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"