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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change series plotting order without changing legend order? 6
How do I find the series associated with a given legend entry. 4
Change series order in a legend 2
chart legend changing when I use Select data 1
How can I change the size of different series within a legend? 5
Changing a charts series order 1
Ignore a Blank Data Series in the Legend 1
select a series that is transparent for formatting in a bar chart 1

Back
Top