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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%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
Highlighted
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?

4 Replies
Highlighted

@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. 

Highlighted

@WesJD can u pls share the file?

Highlighted

@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!