Smart Add Line In Excel Graph

The easiest way to get these new data in the chart is to double-click into the chart area to highlight all the data already shown in the graph.

Add line in excel graph. First of all select the data table and insert a column chart. The data is stored in an Excel Table so that our chart can be dynamic. We want to add a line that represents the target rating of 80 over the bar graph.

Select the range of data go to the insert tab click on column chart click on 2D chart. Enter a new column beside your quantity column and name it Ver Line. Sometimes you need to add a horizontal line to your chart.

We need to show the target value as a horizontal line in the graph. To add a new data series to your chart do one of the following. We will tabulate our data in two columns.

Add the date with the current date to your data for example. Right-click anywhere on the existing chart and click Select Data Figure 3. Click and drag the bottom right corner of the selection to expand it to the Average column.

Prepare your data and create your chart Add a second series that contains your target value this can appear on the same excel sheet or a separate one The X value range for the second series is from 0 to 1 and the Y value corresponds to your target value 150 in the example file Select and copy the second series. Enter the data for the vertical line in separate cells. Hover over the bottom right corner and click and drag the highlighted area of the table to extend the selection to the column Target.

Here I have a record of sales in different months of a year. To add a vertical line to Excel scatter chart this is what you need to do. Now enter a value 100 for Jan in Ver Line column.