Graph on 2 axes w/ 1 line and several series as stacked colu
Graph on 2 axes w/ 1 line and several series as stacked colu
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

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

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Mexico
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's on the X-axis?

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Mexico
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Mexico
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    Mexico
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com