SSRS 3-D 100% Stacked Horizontal Cylinder Chart

This SSRS article shows how to create a 3-D 100% Stacked Horizontal Cylinder chart, add data labels, and format it 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.

• Shared Data Source.
• Embedded Data Source.
• Embedded DataSet.

The Sql query that we used above SSRS example is:

SELECT Geo.[EnglishCountryRegionName] AS [Country]
	,Cust.EnglishEducation AS Education
	,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.EnglishEducation

SSRS 3-D 100% Stacked Horizontal Cylinder Chart

To add a 3-D 100% Stacked Horizontal Cylinder, 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.

Select the 3-D 100% Stacked Horizontal Cylinder chart from the window and click OK to add to the report area.

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

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

Use the toolbar or the properties window to format the 3d 100% stacked horizontal cylinder font, color, and size of the X-axis, Y-axis, data labels, and legend.

Click the preview button to see the 3-D 100% Stacked Horizontal Cylinder chart.

Select the complete chart and change the palette to Excel.

Preview the report.