Fantastic Adding Vertical Line In Excel Graph

To add a vertical line to Excel scatter chart this is what you need to do.

Adding vertical line in excel graph. In the Charts group click on the Insert Columns or Bar chart option. Adding Vertical Shaded Regions to Excel Line Chart. Ask Question Asked 9 months ago.

Create a standard Line Chart and delete the legend. Choose where you want the vertical reference line to cross the x-axis and enter those values below X. Select the data set Click the Insert tab.

You can follow the question or vote as helpful but you cannot reply to this thread. Select the entire table and insert a line chart with markers. Viewed 32 times 0 I am trying to draw a vertical line to a chart I have created in vba but it doesnt seem to work.

Below are the steps to add a secondary axis to the chart manually. And insert this formula to identify the max value. Take a look at this.

This will select the line and open the Format Data Series pane on the right side of your Excel window. Select the data that will be used to create a chart. The easiest way to add vertical line to Excel chart is to draw a line on top of the Excel Chart using shapes.

Now the average vertical line has added into bar chart. Enter the data for the vertical line in separate cells. Add the date with the current date to your data for example.