Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007Back to Charting for Excel archive index
Back to archive home
Changing series order in a chart legend
Posted by Klos on February 14, 2001 12:44 PM
Seems to me older versions of Excel allowed you to change the order of your series in the legend of a chart. A dialog box came up in which you selected a legend item, then you chose "move up/down",to rearrange the order of your series.
Does anyone know if this function is still available in Excel 97 ? I can't find it.
Re: Changing series order in a chart legend
Posted by Dave Hawley on February 14, 2001 1:02 PM
Hi klos
It's still there I promise! Right click on your Data Series and select "format Data Series" now click "series order". There's it is!
Hope this helps
dave
OzGrid Business Applications
Re: Changing series order in a chart legend
Posted by Mark W. on February 14, 2001 2:19 PM
1. Right-click on your chart's series and choose
Format Data Series...
2. Take a look at the Series Order tab.
Echo !
Posted by Dave Hawley on February 14, 2001 5:20 PM
I do believe there's an echo in this message board :-)
OzGrid Business Applications
Re: Echo !
Posted by Mark W. on February 14, 2001 6:02 PM
Yea, I had a bout of tunnel vision and didn't notice that you had already responded.
This archive is from the original message board at www.MrExcel.com. All contents © 1998-2004 MrExcel.com. Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.
Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007Back to Charting for Excel archive index