In this tutorial, we will see how to add conditional colouring to scatterplots in Excel. I came across this trick when I was creating scatterplots for an article on Gestalt laws. I wanted the dots on the plot to be in 3 different colours based on which group they belonged to. There isn't a straightforward way…