ExcelBanter - How do you change the order of the slices in a pie chart?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do you change the order of the slices in a pie chart? (https://www.excelbanter.com/new-users-excel/19516-how-do-you-change-order-slices-pie-chart.html)

weekendbeacher

How do you change the order of the slices in a pie chart?

When creating a pie chart, how do you change the order of the slices slices,
not just rotating them?

John Mansfield

One option is to switch the order of the data in the worksheet. For example,
if the pie is based on 1,2,3,4 - change it to read something different like
2,4,1,3.

----
Regards,
John Mansfield
http://www.pdbook.com

"weekendbeacher" wrote:

When creating a pie chart, how do you change the order of the slices slices,
not just rotating them?

All times are GMT +1. The time now is 11:32 PM.