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

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

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

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

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

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

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.

"Ed Ferrero" wrote:

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

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