Oct 25 2021 10:55 AM
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
Oct 25 2021 01:17 PM
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.