Conditional Colouring in Scatterplots

%3CLINGO-SUB%20id%3D%22lingo-sub-2882900%22%20slang%3D%22en-US%22%3EConditional%20Colouring%20in%20Scatterplots%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2882900%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20All%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20pretty%20basic%20Excel%20user%2C%20and%20I%20am%20trying%20to%20do%20something%20that%20I%20feel%20is%20a%20little%20out%20of%20my%20scope.%20I%20have%20a%20data%20set%20I%20want%20to%20put%20into%20a%20scatterplot.%20The%20problem%20is%20that%20I%20want%20conditional%20formatting%20to%20colour%20the%20points%20in%20the%20plot.%20I%20have%20X%20and%20Y%20value%20columns%20in%20the%20main%20data%20set%20page.%20The%20conditional%20formatting%20comes%20from%20a%20value%20in%20a%203rd%20column.%20The%203rd%20column%20has%20a%20drop%20down%20with%20six%20colour%20coded%20options%20to%20choose%20from.%20I%20want%20my%20points%20in%20my%20scatter%20plot%20to%20be%20colour%20coded%20to%20whatever%20the%20drop%20down%20in%20the%203rd%20column%20has.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20and%20all%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2882900%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2883592%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Colouring%20in%20Scatterplots%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2883592%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195581%22%20target%3D%22_blank%22%3E%40tspalding%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20far%20as%20I%20know%2C%20you%20need%20VBA%20code%20for%20that.%20See%20the%20attached%20sample%20workbook.%3C%2FP%3E%0A%3CP%3ETo%20view%20the%20code%20behind%20the%20button%2C%20press%20Alt%2BF11%20to%20activate%20the%20Visual%20Basic%20Editor%2C%20and%20if%20necessary%2C%20double-click%20Module1.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey All

 

I am a pretty basic Excel user, and I am trying to do something that I feel is a little out of my scope. I have a data set I want to put into a scatterplot. The problem is that I want conditional formatting to colour the points in the plot. I have X and Y value columns in the main data set page. The conditional formatting comes from a value in a 3rd column. The 3rd column has a drop down with six colour coded options to choose from. I want my points in my scatter plot to be colour coded to whatever the drop down in the 3rd column has.

 

Thank you for any and all help

1 Reply

@tspalding 

As far as I know, you need VBA code for that. See the attached sample workbook.

To view the code behind the button, press Alt+F11 to activate the Visual Basic Editor, and if necessary, double-click Module1.