Excel Plot Scatter Graph With Labels. On the Insert tab in the Charts group click the Scatter symbol. I set up an Excel XY scatter plot with some repeating dummy X values so that the data points would stack up.
Select the data you use and click Insert. Go to tab Insert. Select cell range B3C11.
Display text labels in X-axis of scatter chart.
Go to tab Insert. The first column if the series data is plotted in columns is used as X values or more accurately X labels. Columns 1 and 2 contain the X and Y values for the scatter plot column 3 the labels you want to add to each data point column 4 and 5 are integers which represent the code for the marker symbol and color for the data point. Right click on a chart dot and left click on Add Data Labels.
