Excel changes multiple series colors at once

%3CLINGO-SUB%20id%3D%22lingo-sub-1381554%22%20slang%3D%22en-US%22%3EExcel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1381554%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20X-Y%20chart%20with%20five%20series%20of%20markers%2C%20no%20lines.%20When%20I%20change%20the%20color%20of%20the%20markers%20on%20Series%205%2C%20Series%201%20also%20changes%20to%20the%20same%20color%2C%20and%20when%20I%20change%20Series%201%20back%20to%20the%20color%20it%20was%2C%20Series%205%20also%20changes.%20It's%20like%20they've%20been%20linked%20somehow.%20Has%20anyone%20else%20seen%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1381554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1388418%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388418%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664151%22%20target%3D%22_blank%22%3E%40WesJD%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvary-the-colors-of-same-series-data-markers-in-a-chart-395f0c1c-ea89-4fd9-9c5e-fed830e45851%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvary-the-colors-of-same-series-data-markers-in-a-chart-395f0c1c-ea89-4fd9-9c5e-fed830e45851%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1395289%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F402789%22%20target%3D%22_blank%22%3E%40AshaKantaSharma%3C%2FA%3E%2C%20thank%20you%20for%20responding%20but%20that%20link%20does%20not%20address%20my%20problem.%20I'm%20not%20trying%20to%20change%20only%20one%20or%20two%20points%2C%20I'm%20changing%20the%20color%20of%20the%20full%20series%2C%20and%20a%20different%20series%20is%20changing%20at%20the%20same%20time.%20I%20believe%20it's%20a%20bug%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1395337%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664151%22%20target%3D%22_blank%22%3E%40WesJD%3C%2FA%3E%26nbsp%3Bcan%20u%20pls%20share%20the%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1395433%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395433%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3BToday%20I%20can't%20reproduce%20the%20problem.%20I%20think%20it%20originated%20after%20I%20copied%20a%20chart%20within%20a%20sheet%3B%20the%20original%20chart%20behaved%20normally%2C%20but%20the%20copy%20had%20the%20behavior%20I%20described.%20I'll%20watch%20for%20it%20to%20happen%20again%20and%20post%20the%20file%20if%20it%20does.%20Thanks%20for%20your%20interest!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2275698%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2275698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664151%22%20target%3D%22_blank%22%3E%40WesJD%3C%2FA%3E%26nbsp%3BThis%20is%20funny.%20I'm%20trying%20to%20achieve%20the%20exact%20opposite%20of%20what%20you're%20describing%20here.%20I%20have%20a%20dataset%20of%20100%20iterations%20and%20I%20wish%20to%20have%20them%20all%20in%20one%20color.%20Why%3F%20Because%20these%20are%20all%20generated%20simulations%20that%20are%20based%20on%20a%20single%20original%20dataset.%20I%20want%20to%20make%20a%20chart%20where%20only%20the%20original%20dataset%20has%20a%20unique%20color%20from%20the%20other%20100%20iterations%20and%20I%20don't%20feel%20like%20going%20through%20the%20color%20of%20every%20single%20one%20of%20those%20100%20series%20just%20to%20change%20it%2C%20then%20find%20out%20that%20the%20color%20is%20wrong%2C%20so%20I%20end%20up%20changing%20it%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETL%3BDR%20I'm%20trying%20to%20create%20your%20bug%20on%20purpose%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2323202%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1028145%22%20target%3D%22_blank%22%3E%40AhmedMahmoud23%3C%2FA%3E%26nbsp%3BThis%20could%20be%20done%20with%20VBA.%20I%20have%20some%20dummy%20data%2C%20an%20original%20series%20plus%20four%20iterations%20(but%20it%20can%20be%20as%20many%20as%20you%20want%2C%20up%20to%20Excel's%20limit).%20The%20original%20chart%20is%20at%20top%20right.%20In%20%22Chart%20Before%22%20I%20have%20formatted%20the%20original%20series%20with%20a%20black%20line%20and%20the%20first%20iteration%20with%20a%20gray%20line.%20%22Chart%20After%22%20is%20the%20result%20of%20a%20simple%20VBA%20procedure%2C%20below%20the%20screenshot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22FormatSeriesTheSame.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277983i385ABB905C1B487E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22FormatSeriesTheSame.png%22%20alt%3D%22FormatSeriesTheSame.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3ESub%20FormatSeriesTheSame()%0A%20%20If%20ActiveChart%20Is%20Nothing%20Then%0A%20%20%20%20MsgBox%20%22Select%20a%20chart%20and%20try%20again!%22%2C%20vbExclamation%0A%20%20%20%20GoTo%20ExitSub%0A%20%20End%20If%0A%20%20%0A%20%20With%20ActiveChart%0A%20%20%20%20Dim%20iColor%20As%20Long%0A%20%20%20%20iColor%20%3D%20.SeriesCollection(2).Format.Line.ForeColor.RGB%0A%20%20%20%20Dim%20iSeries%20As%20Long%0A%20%20%20%20For%20iSeries%20%3D%203%20To%20.SeriesCollection.Count%0A%20%20%20%20%20%20.SeriesCollection(iSeries).Format.Line.ForeColor.RGB%20%3D%20iColor%0A%20%20%20%20Next%0A%20%20End%20With%0A%20%20%0AExitSub%3A%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325915%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20changes%20multiple%20series%20colors%20at%20once%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325915%22%20slang%3D%22en-US%22%3EThanks%20you%20for%20the%20help.%20It%20worked%20perfectly%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a simple X-Y chart with five series of markers, no lines. When I change the color of the markers on Series 5, Series 1 also changes to the same color, and when I change Series 1 back to the color it was, Series 5 also changes. It's like they've been linked somehow. Has anyone else seen this issue?

7 Replies

@AshaKantaSharma, thank you for responding but that link does not address my problem. I'm not trying to change only one or two points, I'm changing the color of the full series, and a different series is changing at the same time. I believe it's a bug in Excel. 

@WesJD can u pls share the file?

@bhushan_z Today I can't reproduce the problem. I think it originated after I copied a chart within a sheet; the original chart behaved normally, but the copy had the behavior I described. I'll watch for it to happen again and post the file if it does. Thanks for your interest!

@WesJD This is funny. I'm trying to achieve the exact opposite of what you're describing here. I have a dataset of 100 iterations and I wish to have them all in one color. Why? Because these are all generated simulations that are based on a single original dataset. I want to make a chart where only the original dataset has a unique color from the other 100 iterations and I don't feel like going through the color of every single one of those 100 series just to change it, then find out that the color is wrong, so I end up changing it again.

 

TL;DR I'm trying to create your bug on purpose

@AhmedMahmoud23 This could be done with VBA. I have some dummy data, an original series plus four iterations (but it can be as many as you want, up to Excel's limit). The original chart is at top right. In "Chart Before" I have formatted the original series with a black line and the first iteration with a gray line. "Chart After" is the result of a simple VBA procedure, below the screenshot.

 

FormatSeriesTheSame.png

 

Sub FormatSeriesTheSame()
  If ActiveChart Is Nothing Then
    MsgBox "Select a chart and try again!", vbExclamation
    GoTo ExitSub
  End If
  
  With ActiveChart
    Dim iColor As Long
    iColor = .SeriesCollection(2).Format.Line.ForeColor.RGB
    Dim iSeries As Long
    For iSeries = 3 To .SeriesCollection.Count
      .SeriesCollection(iSeries).Format.Line.ForeColor.RGB = iColor
    Next
  End With
  
ExitSub:
End Sub

 

Thanks you for the help. It worked perfectly