Re-arranging legend entries

Xenoun

Board Regular
Joined
Feb 15, 2011
Messages
63
Hello, I have a graph with several legend entries. I want to re-order them, but I am using a couple of trendlines.

The usual method of moving data series up and down in select data doesn't work, presumably because the trendlines are created from those points and hence do not show up there.

Is it possible for me to move the trendline series name up or down in the legend?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
just had a play with this and I assume they will not change as they are in fact "stand alone" lines the list does run from left to right on the table though so if you re arrange your table headings the chart will list in the same order
 
Upvote 0
My data stored in tables can't really be re-arranged, and if that's the only way to move a trendline legend entry then i'd rather not do it anyway.

Its a bit stupid that you cant just drag and drop the series headings in the legend to where you want. It seems to be yet another failing of the microsoft office pack. I never have any problems with windows, but the problems I have with any program in the office kit are never ending
 
Upvote 0

Forum statistics

Threads
1,224,586
Messages
6,179,729
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top