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

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

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
>
>
>