How to change the series order in a LEGEND ONLY...not data

I am using Excel 2003 and need to change the order of the series listed in
the LEGEND only...not the data that drives the chart...is there a way to do
this?

The order of entries in the legend is dependent on the order of data in the
chart, as well as the chart type of each series, and which axis each series
is plotted on. Generally these constraints frustrate any efforts to modify
the order of legend entries.

What I have done with limited success is to make a dummy chart with series I
need in the legend, arranged in the order to provide the legend I want. I
use a screen capture program to copy the legend of this chart, then paste it
into the "real" chart. Whenever something changes in the data or formatting
of the main chart, I need to recreate this static image of a legend.

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


"Steve P" wrote in message
...
I am using Excel 2003 and need to change the order of the series listed in
the LEGEND only...not the data that drives the chart...is there a way to
do
this?

Hi,

You can use a dummy series to generate a sort of "mock" legend in an empty
part of the chart, the limitation being that it has to be within the plot
area, not outside it.

Dave

url:http://www.ureader.com/msg/10297314.aspx