Formatting Pie Chart in SSRS

This article shows how to modify the Pie Chart Legend Title, Legend Position, Title, Font, Pie Chart Model, Pallet, and Display Percentage Values as Labels on Pie Chart in SSRS with an example.

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

Formatting Pie Chart in SSRS 1

Formatting Pie Chart in SSRS

Following are the list of available options for formatting Pie Chart in SSRS

Change Pie Chart Title in SSRS

To replace the Pie Chart title, select the Chart title region

Formatting Pie Chart in SSRS 2

Now, change the Pie Chart title as per the need. Here, we renamed it as Sales By Country because the report is presenting the same

Formatting Pie Chart in SSRS 3

Show Pie Chart Legend Title in SSRS

To view the Pie Chart Legend title, Please select the Legend region, and right-click on it will open the context menu. From the menu, select Show Legend Title option

Formatting Pie Chart in SSRS 4

Please rename the Legend title as per your requirement. Here we named it as Countries

Format Font and Legend Position of a Pie Chart in SSRS

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

Formatting Pie Chart in SSRS 5

Within the General Tab, an option called Legend Position. Use this to adjust the Legend Position by select those dot position

Formatting Pie Chart in SSRS 6

Next, use the Font tab to change the Font Family, Font Size, Font Style and Pie Chart Legend Color

Format Pie Chart Legend Position in SSRS 2014

Change to 3D Pie Chart in SSRS

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

Change Pie Chart in SSRS 2014

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

Change Pie Chart in SSRS 2

Click the Ok button and see the report

Change Pie Chart in SSRS 3

From the above screenshot, you can see that we successfully replaced the Chart Type

Change the Palette of a Pie Chart in SSRS

We can change the Pallet and Pie Chart Color in SSRS. First, choose the Chart and go to properties. Here, change the Pie color by selecting the Palette property as shown in below image

Format Pie Chart Color in SSRS 2014

Here we chose the Chocolate color

Format Pie Chart Color in SSRS 2

Display Percentage Values on SSRS Pie Chart

First, select the Pie Chart data labels, and right-click on them to open the context menu. 

Display Percentage Values on Pie Chart in SSRS 2014

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 display asking, Do you want to set UseValueAsLable to false or not. Please select Yes because we are changing the default value to percent

Display Percentage Values on Pie Chart in SSRS 2

Click Ok and click on the Preview button to see the SSRS formatted Pie Chart Preview

Display Percentage Values on Pie Chart in SSRS 3

We successfully displayed the Percentages as Pie Chart Label in SSRS