Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2011
    Location
    Los Alamos, NM
    Posts
    123
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Excel - coloring points from complex selection of points and sorting

    I have an Excel data sheet that has a number of data columns (9 to be exact). I first have sorted all columns based of 4 columns, i.e. column 2 then 3 then 4 then 5. These 4 columns are binary (0 or 1) and result in 16 different groups. I then color a different column (column 9) in a scatter plot based the different groups --- that isn't a problem. (Yes all the column aren't used here. They are later.)

    I would next like to sort those same data points (column 9) while retaining the color of each point and create a different scatter plot.

    If it is easy, I'm having a brain cramp and can't figure it out. Suggestions?
    Gigabyte Z97X-UD5H , Intel i7 4770K @4.7Ghz using 1.3V
    -- G.Skill DDR3 2400 (2*2Gb) 9-11-11-31
    -- Iwaki MD-20RLZT -> EK Sup. Univ. -> Chiller -> Resev
    -- EVGA GTX680,Klipsch Promedia 4.1
    -- Intel 510 120G, Crucial M4 120G, Samsung 840 Pro 500G
    -- Corsair 1050 in Corsair 730T
    -- Win 10 Pro

  2. #2
    2 Star Lounger
    Join Date
    Aug 2011
    Location
    Los Alamos, NM
    Posts
    123
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Asked another way, can I tag (connect) a symbol to a data point?
    Gigabyte Z97X-UD5H , Intel i7 4770K @4.7Ghz using 1.3V
    -- G.Skill DDR3 2400 (2*2Gb) 9-11-11-31
    -- Iwaki MD-20RLZT -> EK Sup. Univ. -> Chiller -> Resev
    -- EVGA GTX680,Klipsch Promedia 4.1
    -- Intel 510 120G, Crucial M4 120G, Samsung 840 Pro 500G
    -- Corsair 1050 in Corsair 730T
    -- Win 10 Pro

Posting Permissions

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