Chart & Visualization Issues

Add Reference Lines and Selected Data Labels to an Excel Chart

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

Add vertical and horizontal reference lines at specific values and show labels only on selected chart points.

Add Reference Lines and Selected Data Labels to an Excel Chart
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.
Before you start

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.

Solution 1Recommended

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.

1
Create vertical line data

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.

2
Create horizontal line data

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.

3
Add each helper series

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.

4
Format the lines

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.

Add reference lines with helper series in an Excel scatter chart
Match the axis bounds: If the chart's axis bounds change, update the helper values so the lines still span the plot area. For a different chart type, the helper-series setup may need to be adapted.
Chart customization in WPS Office

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. 1. Open the workbook: Open WPS Spreadsheets and use File > Open to select the workbook containing your scatter chart.
  2. 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. 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. 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.
Highlight chart thresholds with vertical and horizontal helper seriesLabel selected points instead of the entire data seriesOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet and chart tools
microsoft office alternative - wps office

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.