none
Can we have combo chart in SqlServer Reporting Services 2008 ? RRS feed

  • Question

  • I want to have a 2charts in a single chart area, e.g., linear chart on a bar chart 


    eg., http://msdn.microsoft.com/en-us/library/Aa964128.moressrschartsfig10(en-US,SQL.90).gif


    I'am using SSRS 2008...

    Thank you
      


     
    Thursday, April 16, 2009 12:59 PM

Answers

  • Hello,

    Steps for achieving this in 2008

    1. Select the chart.
    2. drop the required fields in the drop data fileds here section.
    3. Select the particular filed on which you want to have line chart on the bar chart.
    (Click on one of the required bar on which you want to have line chart.)
    4. Right click and click on change chart type.
    5. Then select Chart type window will be opened select the line chat which you required.

    hope its clear...


    Pavan http://www.ggktech.com
    Friday, April 17, 2009 9:31 AM

All replies

  • Hello,

    Yes we can have two types of charts in a single chart ares. Can you provide more details about the design.

    Hope its clear...

    Pavan http://www.ggktech.com
    Thursday, April 16, 2009 1:10 PM
  • I don't know what exactly you are trying to do, could you give more details?. For more information about advanced charts, check this article.

    Get More Out of SQL Server Reporting Services Charts
    http://msdn.microsoft.com/en-us/library/aa964128.aspx

    http://download.microsoft.com/download/e/8/b/e8b42814-6a0c-40eb-911f-e7adec87f5d5/GetMoreChartsSamples.exe

    http://download.microsoft.com/download/f/1/c/f1cf7b8d-7fb9-4b71-a658-e748e67f9eba/MoreSSRSCharts.doc


    -- Greg
    Thursday, April 16, 2009 1:54 PM
  • All you need to do is add both data series to the chart.  Right click on one of them and select the option to change the chart type to line or bar and you should be all set.   You can even create a chart with multiple chart areas if you want and put the line in one chart and the bar series in the second chart area. 

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    • Proposed as answer by Sean Boon Thursday, April 16, 2009 4:40 PM
    Thursday, April 16, 2009 4:40 PM
  • Thank you pavan for your response, Pavan actuall i want to have a chart like BarLine chart. E.g. when we have bar chart, here i want a connected lines to all the bars might be based on data lable values or any other criteria (e.g. running value)..... pavan i tried to attach a image or snapshot of that but its not getting pasted here.... 



    Thank you


    Friday, April 17, 2009 7:22 AM
  • Thank you for your response sean, sean you mean to say we need to put 2 chart areas separately then take bar chart in one area and line chart in another area..... but i was trying to have barchart and on this barchart i want to have running values where this running values will be connectted by line.... i hope u got it...


    Thank you
    Friday, April 17, 2009 7:27 AM
  • Hello,

    Folow the steps mentioned below

    1. Define the chart type as bar or column graph
    2. In the chart properties click on data tab and select the column for which you wanted to show it as line. 
    3. Click on edit and goto appearance tab and select the check box plot data as line.

    Hope its clear and helpful...


    Pavan http://www.ggktech.com
    Friday, April 17, 2009 7:28 AM
  • But pavan i' am using SSRS 2008, here in chart properties i don't have data tab option.... can u tell the above mentioned steps in terms of Sql server reporting services 2008.....

    Thank you
    Friday, April 17, 2009 8:05 AM
  • Hello,

    Steps for achieving this in 2008

    1. Select the chart.
    2. drop the required fields in the drop data fileds here section.
    3. Select the particular filed on which you want to have line chart on the bar chart.
    (Click on one of the required bar on which you want to have line chart.)
    4. Right click and click on change chart type.
    5. Then select Chart type window will be opened select the line chat which you required.

    hope its clear...


    Pavan http://www.ggktech.com
    Friday, April 17, 2009 9:31 AM
  • You can certainly do this just as I described above.  In fact, in SSRS 2008 we have built in calculated series you can add to your chart to do things like RunningTotals and Moving Averages.  All you need to do is right click on the series or calculated series and choose to change the chart type to a line or bar.  You can mix and match many different chart types, as long as the combination makes sense.

    Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Friday, April 17, 2009 5:27 PM
  • Pavan's answer at the bottom is correct.  I was just trying to point out that in addition to being able to have two different series types (bar and line) in the same chart area, you can also have multiple chart areas, each with multiple series.    For your scenario you can place both series in the same chart area.  You may want to configure a secondary value axis on your chart area so that one of the series isn't hidden because of the discrepancies in the values between it and the other series.

    -Sean
    Program Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs
    Friday, April 17, 2009 5:30 PM
  • Hi

    I tried the same steps and I got it working for column chart type.
    But if the chart type selected as BAR and when i try to change any one of the data value as LINE chart, all the serries changes to LINE.. Please Help..!
    Wednesday, September 23, 2009 12:36 PM
  • Hi Pavan,

    I tried to change my 2-series diagram like you described it above (first select bar chart for the whole chart and then select line chart only for the second series). But it does not work. I tried it with BIDS 2008 Professional Edition.

    Please help.

    Regards,
    Alex
    Tuesday, March 16, 2010 11:21 AM
  • Thanks Pavan :) You rock!
    Application Support
    Wednesday, May 12, 2010 4:11 PM
  • Thanks Pavan. It helped :)
    Friday, October 8, 2010 3:49 AM
  •  

    Pavan,

    Not able to do the 3rd step. Cannot select one of the bar out of 4-5 bars shown in the chart area.

    When I do change chart type, it chages completly. I need a bar chart for some data and line for some data in the same chart area.

    Do we have to set any properties or include anything before doing the 3rd step..???

    -Subbu

    Monday, October 25, 2010 3:00 PM