Unbelievable Insert Line Graph In Excel

Now enter a value 100 for Jan in Ver Line.

Insert line graph in excel. Bar Chart with Line There are two main steps in creating a bar and line graph in Excel. Go to Insert Line Charts Line with Markers. We want to add a line that represents the target rating of 80 over the bar graph.

First of all select the data table and insert a column chart. Here you have a data table with monthly sales quantity and you need to create a line chart and insert a vertical line in it. First we insert two bar graphs.

So now you have a column chart in your worksheet like below. 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. But if youve already invested quite a lot of time in designing you graph you wouldnt want to do the same job twice.

To create a vertical line in your Excel chart please follow these steps. If you forget which button to click just hover over the options. How to add a line to an existing Excel graph.

Add horizontal benchmarkbasetarget line by adding a new data series in an Excel chart This method will take the benchmark line for example to guide you to add a benchmark line baseline or target line in an existing chart in Excel. In the recommended charts click on chart with line bars. Below are the steps you need to follow to create a chart with a horizontal line.

Right-click anywhere on the existing chart and click Select Data Figure 3. Go To Insert Charts Column Charts 2D Clustered Column Chart. Select your data and make a bar chart Insert tab Charts group Insert Column or Bar chart 2-D Bar.