Doughnut Chart Sort

[marcz009]

Is there a way to sort the data in a doughnut chart in descending order without sorting the source data? I can't sort the source because most of the fields are populated by equations.

Thanks

 

[Andrew Poulsom]

You could created a sorted list using the LARGE function and plot that.

 

[ExcelMercy]

1. Right-click the category datafield at the bottom the chart, and then select Category Group Properties.
2. Switch to sorting tab, then click Add button to add a sorting datafield.
3. Formula bar, type =Sum(Fields!YourDatafield.value) - YourDatafield is the datafield on top the chart.

You could also copy/paste just the valves of your data to remove the equations and sort the raw data.