#HOW TO SCATTER CHART EXCEL SERIES#
Repeat these steps for Series B and Series C.ĭo these steps work for you? If you have any questions or suggestions please let me know in the comments below. In the format pane, select the fill and border colours for the marker. To edit the colours, select the chart -> Format -> Select Series A from the drop down on top left. Here is the scatterplot with 3 groups in different colours. Right-click the chart > Select Data: Click ‘Add’ to start adding the data to the chart: Option 2: I prefer to copy my PivotTable and temporarily paste it as values into some empty cells. The chart will be empty ready for you to add the series one at a time. Select Insert and pick an empty scatterplot.Ĭlick OK. Option 1: Select an empty cell and then insert a scatter chart. With the chart selected, click the Chart Design tab to do any of the following: Click Add Chart Element to modify details like the title, labels, and the legend. In our example, the value will be NA.ĭrag the formula down the A column and repeat the same steps for column B and C Click the Insert tab, and then click X Y Scatter, and under Scatter, pick a chart. 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) The axis scaleThe minimum and maximum value that appears on the X or Y axis of a chart. To do this, we use the excel IF condition: For scatter charts, Excel has also established the scale for the X axis.
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.
Next, click the + button on the right side of the chart, click the arrow.
#HOW TO SCATTER CHART EXCEL HOW TO#
Here is the data we are going to work with. This example teaches you how to add error bars to a chart in Excel. 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.