how do you make a graph legend sort high to low?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I'm graphing, the default for the legend seems to show the item with the
lowest value at the top. I resort the data, but no matter what I do, the item
with the lowest value remains at the top of the legend. I really want it to
sort in descending order, but can't find any option to remedy.
Thanks,
David Maerzke
 
Hi David,

The Legend is sorted by series order. You can change this by selecting a
series, and using Format - Selected Data Series... click on the Series Order
tab and move up or down.

Ed Ferrero
http://www.edferrero.com
 
Thanks Ed. I wish it would sort in the order I have it in the spreadsheet as
there are 25 series in one particular graph.
 
Back
Top