Excel puts legend entries into order of chart type and axis, in addition to
the plot order of the series. This means all columns are listed before all
lines. Not much you can do about it.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Philip Drury" wrote in message
...
Have some 'inherited' spreadsheets which are feeding into charts, I want
to
re-order the legend as the order it lists the elements is a little weird
i.e.
the elements are IR1 (%), IR2 (%), IR3 (%) and IR4 (days) - 1, 2 and 3 are
line elements and 4 is a bar. The legend always places IR4 (days) at the
top
when obviously I would like the legend to run in numerical order. Does
anyone have any ideas??
Thanks
Philip