This SSRS article shows how to create a 3-D Clustered Horizontal Cylinder 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. Writing the below code inside the Management studio shows the data set that we use for this example.
The Sql query that we used in this 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 Clustered Horizontal Cylinder Chart
To add a 3-D Clustered Horizontal 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.
Select the 3-D Clustered Horizontal Cylinder chart from the window and click OK to add to the report area.
Use the Plus button or drag the fields to the Values, Category Groups, and Series Groups sections. Here, we added the Sales to Values, the Country Column to Category Groups, and the Education field to the Series Groups section. Next, right-click on the 3d clustered horizontal cylinder and select the Show Data Labels option to add labels.
Use the toolbar or the properties window to format the 3d clustered horizontal cylinder font, color, and size of the X-axis, Y-axis, data labels, and legend.
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.
Click the preview button to see the 3-D clustered Horizontal Cylinder chart.
Select the complete chart and change the palette to Earth Tones.
Preview the report.
