ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table ... Stacked Col & Area Graph (https://www.excelbanter.com/excel-discussion-misc-queries/264611-pivot-table-stacked-col-area-graph.html)

Ken

Pivot Table ... Stacked Col & Area Graph
 
Excel2003 ... I have a Pivot Table "Stacked Col" Chart reflecting operators &
the time they charged to a part ... Sometimes an operation is completed by 1
operator (sometimes multiple operators) ... So far this part of the Chart
works fine ...

Now I would like to add the "time" the operation "should take" ... & I am
thinking I could do this as an "Area" Graph behind the Stacked Cols. (note:
if my operations were completed by a single operator then I can put the Area
Graph behind a Col Graph & all is fine. However, when I have multiple
operators working a single part & I attempt to put an Area Graph behind the
my now "Stacked Col" Graph ... I Fail ... I have been unable to make it
happen ...

So ... Is there a way to setup my Pivot Table to do this? Thanks ... Kha


--
Kha


All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com