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
