Add or Delete a Group in a Chart (Report Builder and SSRS)
Click in the chart data region to display the Chart Data pane. Create groups by dragging dataset fields to the Category Groups and Series Groups areas. To add nested groups, add multiple fields to the area.
Note
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 add a parent or child group to a chart
On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.
Drag a field from the Report Data window to the Category Groups or Series Groups area. To add a parent group, position the cursor in front of an existing group. To add a child group, position the cursor after an existing group.
To edit a category group on a chart
On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.
Right-click the group in the Category Groups area, and then click Category Group Properties.
Add or remove group expressions, filters, sort expressions, and group variables.
Click OK.
To edit a series group on a chart
On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.
Right-click the group in the Series Groups area, and then click Series Group Properties.
Add or remove group expressions, filters, sort expressions, and group variables.
Click OK.
To delete a group from a chart
On the report design surface, click anywhere in the chart to select it. The Chart Data pane appears.
Right-click the group in the Category Groups or Series Groups area, and then click Delete.