Pivot Table ... Stacked Col & Area Graph

K

Ken

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top