Conditional Colouring in Scatterplots

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