Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default 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
Reply
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
Would Like Pivot Table Data on 1 Row instead of Stacked Column Trow Excel Discussion (Misc queries) 1 November 25th 09 03:27 AM
Use values instead of labels on X-axis in Area/Stacked Area Charts Ryan Charts and Charting in Excel 1 November 21st 06 04:14 PM
Stacked area and area chart combo [email protected] Charts and Charting in Excel 6 August 18th 06 02:30 PM
Data Area of Pivot Table and Pivot Charts Missy Charts and Charting in Excel 2 April 13th 06 12:51 AM
Gridlines on Area/Stacked Area charts AgileDarrell Charts and Charting in Excel 1 August 6th 05 12:04 AM


All times are GMT +1. The time now is 05:25 PM.

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

About Us

"It's about Microsoft Excel"