Adding a vertical line to mark a specific point on your chart
A vertical line on an Excel graph marks a single moment or threshold — the date a policy changed, when a project launched, or a target value you want to highlight. Excel does not have a built-in "vertical line" tool, but you can create one by adding a data series that contains only two points stacked at the same x-axis position. This line will sit on top of your existing chart without replacing it.
The method works in Excel 2016 and later on both Windows and Mac. You will add a helper column to your data, then insert a new data series into your existing chart. The line appears when ready and moves if you change the underlying numbers.
Key Takeaways
- A vertical line on an Excel chart is created by adding a two-point data series positioned at the same x-axis value.
- You need a helper column in your spreadsheet with the minimum and maximum values you want the line to span.
- The vertical line is added as a new series to your existing chart, not as a separate object drawn on top.
- Formatting the line's color, thickness, and style happens in the Format Data Series panel, the same place you format other chart elements.
Set up your helper column with the line's endpoints
Open your spreadsheet and locate the data you have already charted. To the right of your existing data, create a new column with a header like "Vertical Line" or "Threshold". This column will hold the values that define where your vertical line appears and how tall it is.
In the first data row of this column, enter the minimum value — usually 0 or the lowest value on your chart's y-axis. In the second data row directly below, enter the maximum value — the highest point you want the line to reach. Leave all other cells in this column empty. If your chart has 50 rows of data but you only want the line at row 15, put your two values in rows 15 and 16, then leave the rest blank.
The x-axis position where the line appears is determined by which row you place these values in. If you put them in row 10, the line will appear at the x-axis label for row 10. If you want the line between two existing data points, you will need to insert a blank row in your original data at that position first.
Add the helper column data to your chart
Click on your existing chart to select it. Right-click the chart and choose Select Data from the menu. The Select Data Source dialog opens.
Click the Add button on the left side of the dialog. A new window called Edit Series appears. In the Series name field, type a name like "Line" or leave it blank. In the Series values field, click the small icon to collapse the dialog, then select the cells in your helper column that contain your two values — for example, if your values are in cells F15 and F16, select that range. Click the icon again to expand the dialog back.
Click OK twice to close both dialogs. Your chart now shows the helper column as a new data series, usually as bars or points. This does not look like a line yet — that comes next.
Change the chart type of the new series to a line
Right-click directly on one of the new data points you just added — the bars or dots from your helper column. Choose Change Series Chart Type. A dialog opens showing different chart types.
Select Line from the list on the left. Choose the line style you prefer — the first option (a straightforward line with no markers) is usually best for a vertical reference line. Click OK. Your helper data now appears as a line on the chart, but it will likely be horizontal or diagonal, not vertical, because Excel is connecting your two points along the x-axis.
Format the line to make it vertical and visible
Right-click on the line you just created and choose Format Data Series. The Format Data Series panel opens on the right side of the screen.
Click the Line Color option and choose a color that stands out against your chart — dark gray, red, or black work well. Adjust the Width slider to make the line thicker if needed. Under Dash type, you can choose a solid line or a dashed pattern.
The line may still appear diagonal or horizontal at this point. To make it truly vertical, you need to may support your helper column values are positioned at the exact same x-axis location. If the line is not vertical, check that both values in your helper column are in the same row number — they should be in consecutive rows (like F15 and F16) so Excel treats them as a single x-axis point with two y-values.
Adjust the line's position if it appears in the wrong place
If your vertical line is not where you expected it, the issue is usually the row position of your helper values. The line appears at the x-axis label that corresponds to the row number where you placed your data.
To move the line, cut your two helper values and paste them into a different row. For example, if you want the line to appear at the fifth data point instead of the tenth, move your values from row 10 to row 5. The chart updates automatically.
If you want the line between two existing data points — for instance, between January and February — insert a new blank row in your original data at that position, then place your helper values there. This shifts all subsequent data down by one row but gives you a precise position for the line.
Add a label to explain what the line represents
Click on the chart to select it. Go to the Chart Design tab at the top and click Add Chart Element. Choose Data Labels and then More Data Label Options. This opens the Format Data Labels panel.
Check the box for Value or Category Name depending on what you want to show. You can also add a text box manually: click Insert at the top, choose Text Box, draw a box near your line, and type an explanation like "Launch Date" or "Target Threshold".
Frequently Asked Questions
Can I add more than one vertical line to the same chart?
Yes. Create a second helper column with two values positioned at a different row, add it as a new data series, and format it the same way. You can add as many vertical lines as you need, each in its own helper column. Use different colors to distinguish them if they represent different things.
What if my chart is a bar chart or column chart instead of a line chart?
The same method works. Add your helper column, insert it as a new series, then change that series to a line chart type. The line will overlay on top of your bars or columns. You may need to adjust the line's color or width to make it visible against the background.
How do I remove the vertical line after I add it?
Right-click on the line and choose Delete. The line disappears but your original chart remains unchanged. If you want to keep the line but hide it temporarily, right-click it, choose Format Data Series, and set the line color to No Color.
Can I make the vertical line extend only partway up the chart instead of the full height?
Yes, by changing the maximum value in your helper column. Instead of using the highest value on your y-axis, use a lower number. For example, if your y-axis goes to 100 but you only want the line to reach 60, put 60 as your maximum value instead. The line will stop at that height.
Why does my line look diagonal instead of vertical?
This usually means your two helper values are in different rows instead of consecutive rows, or Excel is treating them as separate x-axis points. Make sure both values are in the same column and in rows that are directly next to each other (like F15 and F16). If the problem persists, delete the series and recreate it, being careful to select only the two cells you want.