How to: Explode a Single Point on a Pie Chart (Report Builder 2.0)

In addition to the exploded pie chart type, which can be set from the Change Chart Type dialog, you can explode individual slices on a pie chart. This feature highlights an individual data point on the pie chart.

Pie chart with maximum point separated

To display the maximum value of your pie chart as exploded

  1. Add a pie chart to your report. For more information, see How to: Add a Chart to a Report (Report Builder 2.0).

  2. Right-click on any data point in the pie chart. The properties for the series appear in the Properties pane.

  3. In the Data section, expand the DataPoint node, and then expand the CustomAttributes node.

  4. Set the Exploded property to an expression that evaluates to True for the highest value in your dataset. For example, if your dataset is called MyDataSet and the field you have added to the pie chart is called MyField, the following expression will display the maximum data point on your pie chart as exploded:

    =Iif(Fields!MyField.Value >= Max(Fields!MyField.Value, "MyDataSet"), True, False)

You can explode other data points in the series by defining other expressions for the Exploded property, such as the minimum value or a particular category name.

Community Additions