Changing the Legend

  • Thread starter Thread starter Philip Drury
  • Start date Start date
P

Philip Drury

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