Forum Discussion
How to color-code points in a scatterplot by a third, non-quantitative data category
I have three columns of data. Two columns contain numerical data, which I want to plot on the x- and y-axis of a scatterplot. That part's easy. It's the next part that trips me up. I have a third ...
californianmatt not my solution, but I was looking for something similar.
I found this link and feel it might be what you were looking for.
http://daydreamingnumbers.com/how-to/conditional-colouring-to-scatterplots-in-excel/
Hope this helps.