STEP 4:In cells E6 and E7, type the value 0 and 1 respectively. Here, the MAX Formula will return the largest sales amount in the array provided and the MATCH Formula will return the relative position of the maximum value in the array. STEP 3:In cells D6 and D7, use the formula below to extract the sales period with the maximum sales amount. Now, insert the data for your vertical line highlighting the period that achieved the maximum sales. This is how your sales chart will look like: In this example, we will be using a scatter chart to highlight the period in the chart that has the maximum sales. To highlight a point in your chart, you can clearly define its position on the x-axis and create a vertical line for that plot.

So, you will have to adjust this line as and when you update the data.

This line is not linked to the data and hence will not change when you change the data. This will excel add vertical line to chart!Įven though this method is super easy, it comes with its own drawback. STEP 5:To increase the weight of the vertical line, Go to Shape Format > Shape Outline > Weight > 3/4 pt. STEP 4:Draw the line on top of the Chart. STEP 3:Go to Insert > Illustrations > Line. STEP 2:Go to Insert > Line Charts > Line with Markers. STEP 1: Select the data that will be used to create a chart. Follow the steps on how to add a vertical line in Excel graph below: The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes.

How to add trend lines in excel 2016