![]() ![]() If the condition is true we populate the column A with the Y value 25. The condition we use is “label of the column = the group name”.For example, for the first data point, in column A, we check if A = C. IF (Condition, Value if True, Value if False) To do this, we use the excel IF condition: Take the Y column and break it down into 3 columns A, B and C depending on the group the data point belongs to. We want each group to show up in a different colour on our scatterplot. Its a simple table with X and Y values.Įach data point is assigned a group based on a condition. Here is the data we are going to work with. How to add conditional colouring to scatterplots in Excel? 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 to do this in Excel but with a little data wrangling, its very easy to get this done. ![]() I came across this trick when I was creating scatterplots for an article on Gestalt laws. In this tutorial, we will see how to add conditional colouring to scatterplots in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |