Normal and stacked column chart in same report


  • Hi All,

    I want to display normal and stacked column in same chart as show below. but stacked column is not allowing multiple column for category.

    Can any one please help me on this?

    Wednesday, September 18, 2013 9:25 AM


  • Hi Ramesh,

    As per my understand, in SQL Server 2008 we can display normal and stacked column in same chart. However, after Reporting Services 2008 R2 version, we can only get a single chart type on the data region of the chart.

    If you are using SQL Server 2008, we can add another value in the data fields dialog box. Right click the stacked, select Change Chart Type. We can change the value’s Chart Type.
    You can refer to the screen shot below:

    Since this behavior is by design, I recommend you that submit a wish to the Microsoft Connect at Your feedback is valuable for us to improve our products and increase the level of service provided.

    Thank you for your understanding.

    Alisa Tang

    Friday, September 20, 2013 2:17 AM