Export (0) Print
Expand All
Expand Minimize
2 out of 4 rated this helpful - Rate this topic

How to: Explode a Single Point on a Pie Chart

SQL Server 2008

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.

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

  3. 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.