Graph on 2 axes w/ 1 line and several series as stacked colu

[joséxcel]

Grapsh on 2 axes w/ 1 line and several series as stacked columns. I want to graph volume as a line. then different series as stacked columns with it. (4 series, 1 total, and 3 series that add up to the total)

I am currently using the custom for that allows 2 axis but i can't get the stacked column portion, i can only get a line and several columns(but not as stacks).

[ This Message was edited by: joséxcel on 2002-03-18 15:28 ]

[Mark W.]

What's on the X-axis?

[joséxcel]

I have months across my x-axis, the line is volume, the other series are two main types, planned labor and actual labor, the actual labor is further broken out as temp & hourly.

On 2002-03-18 15:42, Mark W. wrote:
What's on the X-axis?

[Mark W.]

On 2002-03-18 15:45, joséxcel wrote:
I have months across my x-axis, the line is volume, the other series are two main types, planned labor and actual labor, the actual labor is further broken out as temp & hourly.

If your X-axis consists of months then where does the Total stacked column go? If, you intend to use...

Jan Feb Mar Total

...as your X-axis, then what's the value of your volume line for the "Total" category?

Can you provide some sample data?

[ This Message was edited by: Mark W. on 2002-03-18 16:19 ]

[Mark W.]

Okay, suppose your data is this...

{"Labor","Jan","Feb","Mar","Total"
;"Planned",100,82,99,281
;"Temp",65,68,81,214
;"Hourly",40,28,25,93
;"Volume",500,450,600,1550}

1. Chart this data as a stacked column chart.
2. Right-click on the "Volume" series and choose "Format Data Series..." from the popup menu.
3. Choose the Secondary axis option on the Axis tab and press [ OK ].
4. Right-click the "Volume" series once more, choose "Chart Type..." from the popup menu, and double-click the Line chart type.

[joséxcel]

OK, this is the data i am working with:

Series 1 (Volume): Dec=600, Jan= 875, Feb=955

S 2(Plan Labor):Dec= $133, Jan=$145, Feb=$127

S 3(Actual Labor)[which i have broken into its pieces and a total]:
Hourly: Dec=$132, Jan=$113, Feb=$121
OT: Dec=$10, Jan=$18, Feb=$14
Temp: Dec=$6, Jan=$0, Feb=$14
TOTAL= Dec=$148, Jan=$131, Feb=$149

I used what you suggested and it did give me volume out separate, but total plan and actual plan (and its pieces) as one big column.
I also tried to manipulate an existing graph with multiple bars for each series and it came close too. but OT wouldn't join the other Actuals. So i had series 1 as volume, series 2 as plan, series 3 as OT, and series 4 as the rest of my actuals.

On 2002-03-18 16:30, Mark W. wrote:
Okay, suppose your data is this...

1. Chart this data as a stacked column chart.
2. Right-click on the "Volume" series and choose "Format Data Series..." from the popup menu.
3. Choose the Secondary axis option on the Axis tab and press [ OK ].
4. Right-click the "Volume" series once more, choose "Chart Type..." from the popup menu, and double-click the Line chart type.

[ This Message was edited by: joséxcel on 2002-03-19 05:12 ]

[Mark W.]

Sounds like you really need a combination of Stacked and Unstacked columns with a Line. Take a look at the following url for an approach to creating a combination of Stacked and Unstacked columns.

http://support.microsoft.com/default...;en-us;Q152381

[joséxcel]

I tried that but it is an excel 95 guide. Somewhat difficult to follow too.

It looks near impossible. I'm going to dig into the Excel hand book. Thanks for your trying though,Mark W.

On 2002-03-19 14:56, Mark W. wrote:
Sounds like you really need a combination of Stacked and Unstacked columns with a Line. Take a look at the following url for an approach to creating a combination of Stacked and Unstacked columns.

http://support.microsoft.com/default...;en-us;Q152381