Nice Excel Add Vertical Line To Line Chart
To create a vertical line in your Excel chart please follow these steps.
Excel add vertical line to line chart. Click on Select Data appears in the right click menu Edit the series. Add a Vertical Line to a Column or Line Chart. The blank cell in the upper left of this range tells Excel.
In some empty cells set up the data for the vertical line like shown below. Within the MS Word document select the image and. Horizontal bar category and N to the number of categories.
Click the Insert tab. To convert the chart into a vertical line chart lets make the following changes. The chart will start to appear as a vertical line chart.
Add Vertical Line using Shapes. In the Charts group click the Recommended Charts option. But if youve already invested quite a lot of time in designing you graph you wouldnt want to do the same job twice.
Hi Thanks I looked at your site but the graph does not work. In that case youll want to add a vertical line across the horizontal bars at a specific value. Use an X value.
Adding a line to an existing graph requires a few more steps therefore in many situations it would be much faster to create a new combo chart from scratch as explained above. Select the periods from sheet for the Y Axis Values. The problem seems to be with the With ActiveChartSeriesCollectionNewSeries-segment of the code.