Forum Discussion
californianmatt
Apr 17, 2018Copper Contributor
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 column which contains categorical data. I want to use the values in this column to color-code all the "points" on the scatterplot.
For example, in the attached screenshot, I would like the points in categories "A", "B", and "C" to each be assigned a color.
I've tried a million things, but cannot for the life of me figure out how to do this. Any help would be much appreciated.
Thank you!
- Kamal_RaghavCopper Contributor
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.
Hi,
Here https://stackoverflow.com/questions/17194105/how-can-i-color-dots-in-a-xy-scatterplot-according-to-column-value are three solutions, two with coding and one with helper columns