+ Reply to Thread
Results 1 to 3 of 3

Scatter legend order issue

  1. #1
    Registered User
    Join Date
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Scatter legend order issue

    Hi,

    I have a legend order issue on my scatter. I want the legend order to be the same as the data series order in the data selection dialogue. See the attached image.
    Is anyone familiar with this issue and can point me in the right direction?

    Thank you.

    Excel scatter legend problem.jpg
    Last edited by ThrainnTh; 11-13-2020 at 12:06 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,783

    Re: Scatter legend order issue

    It appears that you have a secondary axis system in the chart, which means that one or more data series must be assigned to the secondary axis system. When you have a secondary axis system, Excel orders things in the legend according to axis system first, then series order.

    It is difficult to tell from a picture, but I would guess that your "max rate" series is assigned to the secondary axis, and that is why it shows up later in the legend. I would expect to go through each series and more carefully decide which series to assign to the primary and which series to assign to the secondary axes.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-13-2020
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Excel 365
    Posts
    6

    Re: Scatter legend order issue

    That is of course the issue.
    I added the secondary axis to get the tick marks on the right and top sides and forgot to pay attention to it when adding more series.

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scatter Chart - Legend entry
    By michelle 1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-23-2015, 11:28 AM
  2. [SOLVED] Scatter Plot, with legend?
    By dpsersimon in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-02-2013, 09:33 PM
  3. Change order of Legend without changing the order of the chart
    By Grimace in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-22-2012, 11:53 AM
  4. Legend to follow scatter plot colors
    By skorpan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2011, 10:09 AM
  5. scatter plot colors/legend
    By liquidspaces in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2008, 08:10 PM
  6. [SOLVED] Changing order of series appearing in the legend on xy scatter plo
    By JacksonRJones in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-04-2006, 06:10 PM
  7. [SOLVED] XY Scatter Legend when Edit Individual Markers
    By John in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-13-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1