Changing the Legend

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing the name in the legend 2
How to change series plotting order without changing legend order? 6
change the text in the legend of a chart w/o changing pivot text 2
I can get line chart to ignore zeros but the legend still contains 3
Formatting pie charts via VBA 3
How can I change size of chart Legend without losing half of the contents? 1
Any way to change pie chart legend order? 5
How do I bring a certain data series to the front 1

Top