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

D

David Maerzke

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
 
E

Ed Ferrero

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help, please: sorting the Legend 3
Charts - How to have multiple charts share a legend. 2
How do I remove an item from my legend, but leave it on my graph? 2
I can get line chart to ignore zeros but the legend still contains 3
Graphs... Help... Can anyone sort...?! 4
How do you make a hole in a line graph? 2
Sorting by "High", "Medium" and "Low" 7
How do I bring a certain data series to the front 1

Top