Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

legend graph

ResolvedVersion 2013

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,

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

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,

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.

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.