How can I change the order that the series appear in the legend k.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know it is possible to move the series within a legend key in an excel
chart into an order that you require as I have done this before but I can't
remember how! Any help would be appreciated.
 
Hi,

To change the legend order you need to change the data series order.
Select a data series and press CTRL+1 to display the format dialog.
There should be a Series Order tab with a listbox of data series.

Cheers
Andy
 
There are limits to how you can order series. You can't mix different chart types
within each other (e.g., Line chart series always are listed before Scatter series)
or from different axes (primary before secondary). To a small extent you can fake
out Excel, inserting a dummy series with blank cells just to give you a legend
entry, then hiding the legend entry for the visible series. But this approach is
tricky, and difficult to maintain.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top