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

joséxcel

New Member
Joined
Mar 17, 2002
Messages
15
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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?
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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.aspx?scid=kb;en-us;Q152381
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top