Add Reference Lines and Selected Data Labels to an Excel Chart
Question details
Add vertical and horizontal reference lines at specific values and show labels only on selected chart points.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to highlight reference values and selected observations in an Excel chart.
- Observed behavior
- The desired chart displays reference lines at chosen values and labels only on selected data points.
Check the chart type, the values where the lines should appear, and the displayed axis bounds. The helper-series method below is for an XY scatter chart; other chart types may require a different setup.
Add reference lines with helper series in an Excel scatter chart
Use two-point XY series to draw vertical and horizontal lines at specific chart values.
In empty worksheet cells, enter two XY points with the same target X value. Use the displayed Y-axis minimum for the first Y value and the displayed Y-axis maximum for the second.
In another set of cells, enter two XY points with the same target Y value. Use the displayed X-axis minimum for the first X value and the displayed X-axis maximum for the second.
Select the chart, open Chart Design > Select Data, and click Add. Select the vertical helper X and Y cells for one series, then repeat for the horizontal helper series.
Select each helper series and use Chart Design > Change Chart Type to set it to a scatter type with straight lines if needed. Right-click the series and choose Format Data Series to adjust the line and remove its markers.

Label only selected Excel chart points
Add a label to each point you want to highlight without labeling the entire series.
Create Reference Lines and Point Labels in WPS Spreadsheets
Use helper data in WPS Spreadsheets to add reference lines to an XY scatter chart, then add labels to the individual points you want to highlight.
- 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select the workbook containing your scatter chart.
- 2. Enter helper data: In empty cells, enter two XY points for each reference line: repeat the target X value for a vertical line or the target Y value for a horizontal line, using axis bounds for the other coordinates.
- 3. Add and format the series: Select the chart and use Select Data to add each helper range as an XY series. Set the helper series to straight lines and format their markers and line styles as needed.
- 4. Label selected points: Click a data series, click a desired point again, and right-click to add a data label. Repeat for the other points you want to identify.

Frequently Asked Questions
Can I use the same reference-line method for a line chart?
Not necessarily. The steps above assume an XY scatter chart with numeric X and Y coordinates. A line chart may use a category axis, so its helper series and axis setup can differ.
Why doesn't my reference line reach the edges of the chart?
Check the displayed axis bounds by right-clicking the relevant axis and choosing Format Axis. Update the helper series endpoints to match the minimum and maximum bounds.
How do I label just one point instead of the whole series?
Click the series once, then click the desired point again. Right-click that point and choose Add Data Label.
What information is needed for a chart-specific solution?
Prepare an anonymized sample workbook with representative data, the current chart, the desired reference values, and an example of the expected result. The chart type and layout determine the appropriate method.




