Legend in Graph

Resolved · High Priority · Version 2013

Sun 18 Mar 2018, 13:00 Delegate Tsudoi said...

Tsudoi has attended:
Excel PowerPivot course
Excel VBA Introduction course

Legend in Graph

Hi,
Is there anyway I can change only the order of texts inside legend without actually changing the graph order at the same time.
Bar graph shows the order correctly but just want to move around the names inside the legend box.

Thanks,

Tue 20 Mar 2018, 20:28 Trainer Jens said...

RE: Legend in Graph

Hi Tsudoi

Thank you for the forum question.

You can change the legend to fixed names.

Please follow the link below.

https://support.office.com/en-ie/article/modify-chart-legend-entries-d822dd57-af28-4c3e-93d1-d320e6239843

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 22 Mar 2018, 11:23 Delegate Tsudoi said...

RE: Legend in Graph

Hi Jens,

Thanks for that.
What I like to do is not to edit but to change the order of entries within the legend without affecting the chart.
Sorry I did not make my question clearer.

Thanks,

Fri 23 Mar 2018, 08:38 Trainer Jens said...

RE: Legend in Graph

Hi Tsudoi,

The legend will always be sorted in the same order as the chart.

You only have the option to change the order, if you manually edit the legend.

You may be able to write a VBA code to do.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 30 Mar 2018: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips