Excel 2016 Scatter Plot With Labels. The label in the cell changes. IF Condition Value if True Value if False The condition we use is label of the column the group nameFor example for the first data point in column A we check if A C.
Change the name of the series to the cell reference for the label for that XY pair. This is what you want to do in a scatter plot. Dialog right click on the chart to change the series as follows.
Right click on your data point.
Click on Axis Titles. Click on select range. Select the series of labels then select. To do this we use the excel IF condition.
