Skip to Content
author's profile photo Former Member
Former Member

Change legend sort order in line chart

I have a grouped line chart with years along the bottom. The legend is in alphabetical order, but is a different order than the markers. The Chart Options' Legend tab offers no option to change the legend sort order. How can I resort the legend, so it follows the order of the lines on the chart?

I want to show the last year's counts in descending order, like this example:

In 2010, the highest number of fruit sold was apples. The next highest was bananas. The legend text for apples should be at the top of the legend list, and bananas should be beneath it, and so on. And of course the legend colours should match the corresponding line on the chart.

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2012 at 05:49 PM

    Hi Prebanks,

    The follwing may help you.

    Right click on Line chart and select Chart Expert.

    Select Data tab and select the field in On Change Of Drop down box.

    Then Order... and TopN... Buttons will appears.

    Then select Order.. button and select Specified Order from the Drop Down box.

    It will open Chart Sort Order windowm, from the Named Group drop down box select the specified Order or else if you want to create an Order based on Condition then select New button and set condtion.


    Praveen G

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.