Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stakced Bars with Line? (XP)

    Hi - quick Chart Question

    Is it possible to have a combination of a stacked bar chart together with a line on second axis?

    I can't seem to find a way of getting this.
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stakced Bars with Line? (XP)

    Yes. First create a stacked column chart for all series, including the one that should end up as a line.
    Then, select the series that you want to change into a line.
    Select Chart | Chart Type... and select the line chart option you want. Click OK.
    Select the line, then select Format | Series...
    Activate the Axis tab and specify that the series is to use the secundary value axis.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stakced Bars with Line? (XP)

    Thanks Hans. Will try this tomo. [img]/forums/images/smilies/smile.gif[/img]
    Thanks,

    pmatz

  4. #4
    Star Lounger
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stakced Bars with Line? (XP)

    Hi Hans,

    afaik this is possible to do with columns as you explain, but not so easily done with bars (At least until XL 2002)

    John Peltier shows a possibility how to do it with bars and line. http://peltiertech.com/Excel/Charts/BarLineCombo.html

    It's quite tricky, but from my experience it works well.

    Wolf

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Stakced Bars with Line? (XP)

    Thanks. I know that M

  6. #6
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stakced Bars with Line? (XP)

    Hi guys, I did indeed mean a Column Chart (nicely picked up Hans!) and thanks for the link Wolf, for future reference. I got the Column Chart with the stacked columns and line with second axis working really well, so I'm happie <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>

    (wish I spelt 'Stacked' correctly though <img src=/S/woops.gif border=0 alt=woops width=58 height=36> )
    Thanks,

    pmatz

Posting Permissions

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