Select Period with Maximum Sales and then click on the Edit button. STEP 10:Again, Go to Chart Design> Select Data to open the Select Data dialog box. STEP 9:In the Change Chart Type dialog box, select Scatter with Straight Line and check the box for the secondary axis. STEP 8:Go to Chart Design > Change Chart Type. STEP 7:In the Edit Series dialog box, select cell D4 for the Series name box and cells D6:D7 for the Series Values box. STEP 6:In the Select Data Source dialog box, click on the Add button. STEP 5:Click on the chart and then Go to Chart Design Tab > Select Data. 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.

Insert scroll bar excel 2016