Chart for combined Bar and line


  • Hi,

    Is it possible to have chart which have combined of bar and line graph?
    We have requirement to show chart with Bar and line combined for different scales and values.

    I am using SQL Server 2005 SSRS.
    Friday, April 17, 2009 6:34 AM

All replies

  • Hi,

    It is not possible to have two chart types in one chart in ssrs 2005 

    We can do it in SSRS2008
    Rajesh Jonnalagadda
    Friday, April 17, 2009 6:51 AM
  • Hi Avinash,

    It is possible to have line graph included in bar or column graphs.
    For this you need to define the chart type as bar or column graph and then in the chart properties goto data tab and select the column for which you wanted to show it as line.  Then click on edit and goto appearance tab and select the check box plot data as line.

    With Regards
    Giri Duddu
    • Proposed as answer by Sean Boon Friday, April 17, 2009 5:39 PM
    Friday, April 17, 2009 6:56 AM
  • Hi Giri,

    Thanks for your reply.I have tried your soultion and it's working.
    But It is possible to have 2 different scales on  single chart,i.e. Y-axis and Z -Axis?

    Saturday, April 25, 2009 3:52 AM
  • Hi I think SSRS 2008 had ability to have seconday axis. please check Thanks
    Saturday, April 25, 2009 5:00 AM
  • SSRS 2008 does indeed support two Y-Axis.

    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights.
    Sunday, April 26, 2009 10:13 PM
  • Hi

    I have also been trying to get a line chart appear on top of a bar chart.

    When i go to the data tab in order select "plot as line", the option is greyed out and i cant find away to select it!

    How is this feature enabled????


    Tuesday, August 04, 2009 4:24 PM
  • "Plot as line" works in combination with a column chart, not a bar chart.

    Robert Bruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Proposed as answer by TheSqlBanana Thursday, August 13, 2009 11:07 AM
    Tuesday, August 04, 2009 4:42 PM