Change a Chart Type (Report Builder and SSRS)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
When you first insert a chart into a report, the Select Chart Type dialog appears. If you cancel this dialog, a Column chart type is added by default.
At any point when designing the report, you can change the chart type to something more suitable to the report. It is important to select the correct chart type for your data so that it can be interpreted correctly. You should understand each chart type's characteristics to determine what chart type is best suited for your data. For more information, see Chart Types (Report Builder and SSRS).
When multiple series are displayed on a chart, you may want to change the chart type of an individual series. You can only change the chart type of an individual series if the chart type is Area, Column, Line, or Scatter. For all other chart types, all series in your chart will be changed to the selected chart type.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To change the chart type
In Design view, right-click the chart and then click Change Chart Type.
When there are multiple series on a chart, you must right-click on the series, not the chart, which you want to change.
In the Select Chart Type dialog box, select a chart type from the list.