WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to add vertical line to excel chart in excel graph

July 21, 2022

The internet is plenty of inventive methods for adding a vertical line to your chart. If you are reading this, it is safe to assume that you are searching for an automatic method to avoid manually dragging the line(s) you drew on your spreadsheet each month.

Embedding a vertical line shape into a chart

1. On your spreadsheet, you must first draw a line shape. To accomplish this, select the Insert tab and activate the Shapes menu button.

  1. Your cursor should go to Draw Mode once you select the line button.

  2. Click where you want your line to start and drag downward to lengthen it while holding down the SHIFT key on your keyboard.

  3. If your line seems somewhat slanted, you may force it to be zero by setting the width of the line to 0. (in the Shape Format tab). Holding down the SHIFT key while adjusting the length of your line will guarantee that it stays absolutely vertical.

Format your line in excel

You'll probably want to change your line's formatting from the default appearance. The Shape Format tab offers you a wide range of formatting choices. When you pick the line shape, this contextual Ribbon tab appears.

How to create a dynamic vertical line in your chart in excel

  1. This is going to be the solution for you if you're seeking for a more automated/long-term way to add a vertical line to your chart.

  2. The method we'll employ combines your present chart with a single-pointed Scatter Plot (x, y). The Scatter Plot's solitary point will determine where the vertical line will be drawn.

  3. Then, by activating vertical Error Bars (margin of error indications), we may use the chart to graphically represent a vertical line.

Chart starting point in excel

  1. I'm going to presume that you have already built your chart and are attempting to add the vertical line to it. In light of this presumption, I won't go through the process of making an Excel chart with you.

  2. For this demonstration, we'll start with the chart below and proceed to add a vertical line dividing the Actual months from the Forecast months.

Note: This was an attempt to show you how to add vertical line to excel chart in excel, in both windows and mac. To get the newest version of WPS Office, you must first access this operating interface.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.