This SSRS article shows how to create a 3D 100% Stacked Cylinder chart, Show Data Labels, and format the 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 we use for this example.
The Sql query that we used in this 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,Cust.EnglishEducation
SSRS 3D 100% Stacked Cylinder Chart
To add a 3D 100% Stacked 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 3D 100% Stacked 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 column to Values, Country to Category Groups, and Education column to the Series Groups section. Next, right-click on the 3D 100% stacked cylinders and select the Show Data Labels option to add labels.
Use the toolbar or the properties window to format the 3D 100% stacked Cylinder font, the color of the X-axis, Y-axis, data labels, and legend. Next, click the preview button to see the 100% Stacked Cylinder.
Select the chart and change the Palette property to Fire.
Preview the 3-D 100% Stacked Cylinder report with custom colors.
