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

  • Thread starter Thread starter Steve P
  • Start date Start date
S

Steve P

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