Line + Bar in a single chart

  • Arunkumar S P

    SSCertifiable

    Points: 6415

    Is it possible to have line and bar chart in a single chart??

    Kindly help me

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • Abs-225476

    Hall of Fame

    Points: 3483

    Hi,

    I think this is possible, you will need to plot all the data in a bar or column chart , make sure that the data for the line is a separate value. You can then edit the appearance of this value by going into the chart properties, data tab and then select the value and edit and then go to appearance tab and at the bottom of the window check the 'plot data as line' check box.

    Hope this helps.

  • Arunkumar S P

    SSCertifiable

    Points: 6415

    Thanks Abs-225476.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • ricky.chauvin

    SSC Enthusiast

    Points: 132

    Awesome, didnt realise this was possible. I really need to get into charting in a big way. Does anyone know of a resource which displays what is possible in 2008?

  • alex_2356

    SSC Veteran

    Points: 298

    Abs-225476 (12/23/2009)Hi,

    I think this is possible, you will need to plot all the data in a bar chart or column chart , make sure that the data for the line is a separate value. You can then edit the appearance of this value by going into the chart properties, data tab and then select the value and edit and then go to appearance tab and at the bottom of the window check the 'plot data as line chart check box.

    Hope this helps.

    Oh, I can't agree more with you!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply