02 March, 2011

Rearranging/reordering data series in an Excel chart/graph

 Let's say you have this graph, and you want to rearrange the legend on the right so that it goes 22 h - 4 h - ... - 0 h, so it matches the order of the curves. I couldn't find an easy way to do it on my own, so I searched and found a solution at http://www.mrexcel.com/archive/Chart/10197.html.

 Right click on any curve and select "Format Data Series"

There is an option called "Order" that lets you manually order the curves any way you like!

No comments:

Post a Comment