| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I modify the legend in Excel? | Charts and Charting in Excel | |||
| Sort data for graph only | Excel Discussion (Misc queries) | |||
| Can it be done | Excel Worksheet Functions | |||
| how do i make a graph from text ? | Charts and Charting in Excel | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Linear Mode
