Stunning Add A Vertical Line To Excel Chart
This will enable you to see a dynamic date range in your graph that cha.
Add a vertical line to excel chart. Add a new data series to your chart do one of the following. In this post Im going to show you a way to create an Excel bar chart with a vertical line. We are almost done.
This will select the line and open the Format Data Series pane on the right side of your Excel window. Insert a column in the table. Add Vertical Line using Shapes.
Under Chart Tools on the Design tab in the Data group choose Select. Use this data to make a column or line chart. Select the data that will be used to create a chart.
Enter the data for the vertical line in separate cells. Unfortunately adding a vertical line to a bar chart isnt a simple feat in Excel but Ill step you. Click secondary axis check box and select scatter with straight lines.
Click on OK and well move on. You will instantly see a vertical straight line added to the gantt chart. To add a vertical line to Excel scatter chart this is what you need to do.
Follow the steps on how to add a vertical line in Excel graph below. This single amount will be used to provide a vertical dotted line. On the right side you will see newly inserted secondary vertical axis double click on it to invoke format axis options.