+ Reply to Thread
Results 1 to 2 of 2

Symbols and lines change color when I reorder data sets

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2019 Professional Plus
    Posts
    11

    Symbols and lines change color when I reorder data sets

    I am using Excel 2016. I have noticed an issue that I've never had in any previous version. I am using "Scatter with Straight Lines and Markers". In one example I have 6 data sets that I have plotted: 1) three data sets with markers, and 2) three without markers. In the three with markers, one is linked to data in columns in a separate tab, and two are linked to data in other spreadsheets. For the three without markers, I have input the upper and lower X and Y values in the "select data" window. (I don't know if any of this is relevant, but I am including to be as complete as possible).

    Issue: I am adding a new data set, and I want to change the order so the new data set comes up first in the legend. So I use the "up arrow" in the "select data" window (note that this happens whether or not I have even linked to any data yet, sometimes I have just put in a label). As I do this I the colors might change for one or more data sets. In the example I am referencing right now, I can move the new set up in the order past the three w/o markers and not have any color changes. Up one more, no color changes (it is now in the third position). Up to the second position and the green lines turn gray. Up to the top, and the green symbols turn the same gray.

    To top it off, when I then use the down arrow, it won't necessarily return to all original colors. I can hit cancel, and it won't go back to all original colors. After hitting cancel, I can't undo. If I hve linked to the data, a different data set will changes colors, and to different colors than the gray in the above example.

    I completely closed down Excel and restarted. Same thing.

    I have attached three screen captures.

    Any ideas?

    TIA
    Attached Images Attached Images

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Symbols and lines change color when I reorder data sets

    I may have some code I can adapt that will allow you to select and "lock down" the color for a series. Include a sample workbook.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. [SOLVED] 2 sets of data. Need to compare the values of matching lines
    By thega in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-08-2017, 08:41 AM
  2. [SOLVED] Conditional formattimng where I can change the color of the icon sets
    By cmorten82 in forum Excel General
    Replies: 2
    Last Post: 04-21-2016, 05:15 PM
  3. Reorder Lines to Match
    By schweitzerc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2014, 04:40 PM
  4. [SOLVED] plotting 2 sets of data on the same scatter plot using 2 symbols
    By Wombat18 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-07-2013, 04:04 AM
  5. Hi-Lo lines locked to 2 data sets
    By Grimace in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-24-2010, 09:16 PM
  6. can excel reorder lines of text?
    By preowned_male in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-19-2005, 10:05 PM
  7. [SOLVED] lines/bar chart- on max valued bar, change color
    By BOB-THE-K in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-12-2005, 01:06 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