Problem Statement:

How do you customize the Legend Text on a chart? by default, it’s going to show you the name that you have in the Data Set, but sometimes that’s not what you want to display so how do you change the name?

It’s really useful when you don’t want to change the name of field in the dataset or when you are using an expression as an item on the chart and you need to display a business user friendly name on the report:

Solution:

1. Go to Chart Data Properties:

2. To change the Legend Text of “Sales Amount CY” – Navigate to series properties of the “Sales Amount CY” series:

3. Go to “Legend” and enter the Text in the “Custom Legend Text“:

4. You can customize text for all legends on your report by navigating to the series properties.

Conclusion:

In this post, I walked you through how you can customize the legend name/text in SQL Server Reporting Services.