Add a Drop Line to One Excel Chart Data Point
Question details
The user wants a drop line for one selected point in an Excel chart.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Highlight a milestone in a chart while keeping the line linked to changing data.
- Observed behavior
- Excel's standard drop lines apply to a chart series rather than only one selected point.
Identify the source cell for the point you want to highlight. The steps below assume a line chart with a positive value and a linear vertical axis whose baseline is zero.
Use a helper series and error bar for one chart point
Create a data-linked vertical line for a single point without applying drop lines to the entire series.
A custom vertical error bar can imitate a drop line. Linking its length to the selected value lets it update when that value changes.
In the chart's source worksheet, add a column named Milestones. Reference the selected point's value in its matching row and enter =NA() in the other rows. Enter 0 in a separate cell for the positive error value.
Select the chart, choose Chart Design > Select Data > Add, and select the Milestones cells as the series values. Keep the helper series on the same axis as the original series.
Select the Milestones point, then choose Chart Design > Add Chart Element > Error Bars > More Error Bars Options. Select the vertical error bar, choose Minus and No Cap, and set Error Amount to Custom.
Click Specify Value. For Positive Error Value, select the cell containing 0; for Negative Error Value, select the cell containing the milestone value. Click OK.
Right-click the vertical axis and choose Format Axis. Confirm that the axis uses a linear scale and that the horizontal axis crosses at zero. Right-click the error bar and choose Format Error Bars to set its color or dash style; format the Milestones marker separately if desired.

Work with spreadsheet charts in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and charts. Open compatible Excel files to make moving between office suites easier; it does not change Excel's drop-line behavior.

Frequently Asked Questions
Can I apply Excel's standard drop lines to just one point?
Standard drop lines apply to a chart series, not an individual point. Use a helper series with a custom vertical error bar to imitate a line for one selected point.
Will the line move when the chart data changes?
Yes. Reference the source value in the Milestones series and use that value as the custom negative error amount. The point and its line will update when the source cell changes.
How can I change the line to a red dashed style?
Right-click the helper series' error bar, choose Format Error Bars, and use the Fill & Line options to change its color and dash type.
Why does the line not reach the horizontal axis?
Check Format Axis to see where the horizontal axis crosses the vertical axis. For the zero-baseline method, it must cross at zero, and the negative error value must match the selected point's value.




