SSRS Stacked Column Chart

This SSRS article shows how to create a Stacked Column Chart, Show data Labels, and format fonts and colors with an example. To demonstrate this Stacked Column Chart example, right-click on the Datasets folder to create a new DataSet.

The below screenshot shows the data set that we use for this SSRS Stacked Column Chart example.


The Sql query that we used above SSRS example is:

SELECT Terry.SalesTerritoryGroup AS TerGroup,
	SUM(Fact.SalesAmount) AS Sales
FROM DimProduct AS Prod 
   INNER JOIN FactInternetSales AS Fact 
      ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN DimSalesTerritory AS Terry 
      ON Terry.[SalesTerritoryKey] = Fact.[SalesTerritoryKey] 
GROUP BY Terry.SalesTerritoryGroup, Prod.Color

SSRS Stacked Column Chart

To add a Stacked Column Chart, right-click the report area, choose Insert, and then the chart option from the context menu. Otherwise, drag and drop the chart from the toolbox to the report area.

Insert a Chart

Select the Stacked Column Chart from the window and click OK to add to the report area.

Choose SSRS Stacked Column Chart

Use the Plus button or drag the fields to the Values, Category Groups, and Series Groups (optional) sections.

Automatically Generated Graph with Dummy Data

Here, we added the Sales column to Values, the Color column to Category Groups, and TerritoryGroup to the Series groups section.

Add columns to Values, Category, and Series Groups

Preview the SSRS Stacked Column Chart Report.

Report Preview

Right-click on the Stacked Column Chart and select the Show Data Labels option to add labels.

Show Data Labels in SSRS Stacked Column Chart

Right-click the Data Labels and select the Series Label Properties option to format Stacked Column Numbers to show values in Thousands with a currency symbol.

Format the Data Labels Numbers

Next, right-click on the legend and choose Legend properties to format the style, change position, etc.

Format Legend Position and font

Use the toolbar or the properties window to format the Stacked Column Chart font, the X-axis and Y-axis color, data labels, and legend.

Format Fonts and Colors of the Axis

Right-click the bars and choose the Series Properties option to format the borders, font, background color, etc.

Change Border colors of a SSRS Stacked Column Chart

Preview the report.

SSRS Stacked Column Chart Preview