SSRS 3-D Clustered Cylinder Chart

This SSRS article shows how to create a 3-D Clustered Cylinder chart, show data labels, and format colors and fonts 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.


The Sql query that we used above SSRS example is:

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

SSRS 3-D Clustered Cylinder Chart

To add a 3-D Clustered Cylinder, 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 3D Clustered Cylinder chart from the window and click OK to add to the report area.

Choose SSRS 3-D Clustered Cylinder Chart

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

Add Columns to Values, Category Groups, and Series

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

Show Data labels in SSRS 3-D Clustered Cylinder Chart

Right-click the Data Labels and select the Series Label Properties option. Use this window to format Numbers as Currency and show values in Thousands.

Format dat label Numbers

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

Format the Fonts and colors

Click the preview button to see the 3-D Clustered Cylinder chart.

Preview the SSRS 3-D Clustered Cylinder Chart

Select the complete chart and change the palette to Pastel.

Change the Palette

Preview the report.

SSRS 3-D Clustered Cylinder Chart preview