SSRS 100% Stacked Bar Chart

This SSRS article shows how to create a normal and 3D 100% Stacked Bar chart, Show Data labels, and format fonts and colors with an example. To demonstrate this example, right-click on the Datasets folder to create a new DataSet. 

The below screenshot shows the data set that we use for this example.

DataSet

The Sql query that we used above SSRS example is:

SELECT Geo.[EnglishCountryRegionName] AS [Country]
	,Cust.EnglishOccupation AS Occupation
	,Cust.MaritalStatus
	,SUM(Fact.SalesAmount) AS Sales
FROM  DimCustomer AS Cust
INNER JOIN FactInternetSales AS Fact ON Cust.CustomerKey = Fact.CustomerKey
INNER JOIN [DimGeography] AS Geo ON Cust.GeographyKey = Geo.GeographyKey
GROUP BY Geo.[EnglishCountryRegionName],Cust.EnglishOccupation,Cust.MaritalStatus

SSRS 100% Stacked Bar Chart

To add a 100% Stacked Bar, right-click the report area, choose Insert, and then choose 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 100% Stacked Bar Chart from the window and click OK to add to the report area.

Choose SSRS 100% Stacked Bar Chart

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

Add Columns to Values, Category, and Series Groups

Here, we added the Sales column to Values, Country to Category Groups, and Occupation field to the Series Groups section. Next, right-click on the 100% stacked bars and select the Show Data Labels option to add labels.

Show Data labels in SSRS 100% Stacked Bar Chart

Use the toolbar or the properties window to format the 100% stacked bar chart font, the color of the X-axis, Y-axis, data labels, and legend.

Format Fonts and Colors

Click the preview button to see the 100% Stacked bar chart.

SSRS 100% Stacked Bar Chart Preview

Right-click on the chart and choose the Change Chart Type option. 

Select Change Chart Type option

Next, select the SSRS 3-D 100% Stacked Bar Chart from the window.

Choose 3D

Preview the report.

SSRS 3D 100% Stacked Bar Chart Preview