View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Philip Drury Philip Drury is offline
external usenet poster
 
Posts: 32
Default Changing the Legend

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