View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Ed Ferrero
 
Posts: n/a
Default 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