Excel Scatter Plot Labels Macro. Change the name of the series to the cell reference for the label for that XY pair. Make sure you select as many cells as there are data.
Make sure you select as many cells as there are data. Select the custom data labels you want to assign to your chart. Recently a client asked me if it was possible to create an Excel scatter plot of his products adding a label on each data point and using different colors and symbols for different types of products.
Do not select any other columns to avoid confusing Excel.
Display text labels in X-axis of scatter chart Actually there is no way that can display text labels in the X-axis of scatter chart in Excel but we can create a line chart and make it look like a scatter chart. Do not select any other columns to avoid confusing Excel. Then use the Select Data. Line with Markers to select a line chart.
