Pie Chart Item Order

[geniusgirlca]

Hi Guys,

I need your help here! I am trying to change the order of the slices in a pie chart. For example, my data is sorted alphabetically, but in the pie chart, I'd like to switch a couple items around without changing the order in my source data. Does anyone know a quick solution? Thank you so much!

 

[Jon Peltier]

Excel plots the data the way it appears in the worksheet. Use an intermediate table that is sorted the way your chart should be, but don't display this table.

 

[geniusgirlca]

Thanks a lot!