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

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" <(E-Mail Removed)> wrote in message
news:B4082F79-0B97-4605-8332-(E-Mail Removed)...
> 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