How to sort column graphs in Excel?
Posted on 2011-05-11
I have a column type graph in Excel. Without changing the source of this graph i would like to sort it in descending order. So the graph will look better.
I tried changing the order from select data menu. But it only accepts the legend order change. I also tried switching the row column and then sort it. But then, it didn't let me to change it back after changing the order.
How can I do that?