Formatting Column Chart in SSRS

In this article, we will show you the steps involved in the Formatting Column Chart in SSRS. It includes how to change the Column Chart Title, Legend Title, Legend Position, Column Chart Font, Column Chart Model, Column Chart Type.

We will also explain, How to Display Percentage Values as Labels on Column Chart and Calculating the Average of Column Chart in SSRS or SQL Server Reporting Services with an exa

Formatting Column Chart in SSRS

To explain the available Format options, We are going to use the below-shown report. Please refer to the Column Chart article to understand the Data Source and Dataset we used for this SSRS report.

Column Chart 7

Change the Title of a Column Chart in SSRS

To change the Column Chart title, Please select the Chart title region as we have shown in below screenshot

Change Title of a Column Chart 1

Now, change the title as per your requirement. Here we changed as 2011 & 2012 Country Sales because the report is displaying the same

Change Title of a Column Chart 2

Format Legend Position of a Column Chart in SSRS

Select the Legend region, and right-click on it will open the context menu. From it, please select Legend Properties option

Format Column Chart Legend 1

TIP: To display the Column Chart Legend title, Please select the Show Legend Title option from the above screenshot

Within the General Tab, change the Legend Position by select those dot positions

Format Column Chart Legend Position 2

Next, we can change the Font Size, Font Family, Font Style, and Color of a Column Chart Legend using Font Tab so on.

Change Axis Titles of a Column Chart in SSRS

Select the Axis Title region and right-click on it will open the context menu. From the menu, please select Axis Title Properties option as we shown in below screenshot

Format Column Chart Horizontal Axis 1

Once you select the Axis Title Properties option, a new window called Axis Title Properties to configure the Title Text, font etc. For now, we are changing the title text as Countries and alignment as Center

Format Column Chart Horizontal Axis 2

Next, We can change the Font Size, Font Family, Font Style and Color of a Column Chart Axis using Font Tab. Please change the Vertical Axis title also.

Change Column Chart Type in SSRS

The reporting service allows us to change the chart type even after creating the chart. First, select the Column chart and right-click on it will open the context menu. Please select the Change Chart Type… option from the context menu

Change Column Chart Type 1

Once you select the Change Chart Type… option, it will open a new window to select the new chart. Here we are selecting 3D Column chart

Select 3D Column Chart Type 2

Click Ok to finish

Formatting Horizontal and Vertical Axis of a Column Chart in SSRS

Select the Horizontal Axis region and right-click on it will open the context menu. From the menu, please select Horizontal Axis Properties option as we shown in below screenshot

Format Column Chart Horizontal Axis 3

Once you select the Horizontal Axis Properties option it will open a new window to format the properties. Here we are changing the select Label fonts. You can try others as well.

Format Column Chart Horizontal Axis 4

Now, select the Vertical Axis and go to the Vertical Axis Properties option to configure them. Here, We formatted the Numeric values by changing them to currency.

Format Column Chart Vertical Axis 2

Click Ok button and preview the report.

Format Column Chart Vertical Axis 3

From the above screenshot, you can observe that We successfully changed and formatted the Column Chart

Display Percentage Values as Data Labels in SSRS Column Chart

First, select the data labels of the Year 2011 on the Column Chart and then right-click on them will open the context menu. Please select the Series Label properties… option from the context menu

Percentage Values as Column Chart Labels 1

Within the General Tab, Please select the Label data to #PERCENT from the drop-down list. Once you select the percent a pop-up window will be displayed asking, Do you want to set UseValueAsLable to false or not. Please select Yes because we are changing the default value to percent

Percentage Values as Column Chart Labels 2

Click Ok to finish configuring percentage values for the Year 2011. Now, Repeat the same process for the Year 2012

Percentage Values as Column Chart Labels 3

We successfully displayed the Percentages as Column Chart Label

Calculating the Average of a Column Chart in SSRS

First, select the data labels of the Year 2011 on the Column Chart and then right-click on them will open the context menu. Please select the Add Calculated Series… option from the context menu

Calculating Mean Values for Column Chart 1

Once you select the Add Calculated Series… option it will open a new window called Calculated Series Properties.

Here we are going to calculate the Mean so select Mean from the drop-down list as shown below. You can try others as well

Calculating Mean Values for Column Chart 2

Click Ok to finish calculating the Average for the Year 2011. Now, Repeat the same process for the Year 2012

Calculating Mean Values for SSRS Column Chart 3

Click on the preview button to preview the SSRS Column Report.

Calculating Mean Values for Column Chart 4

Comments are closed.