Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

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