How To Use Excel Line Graph

Enter your graph s data.

How to use excel line graph. Go to insert menu charts tab select line charts symbol and in that we can select the customized line chart as per the requirement. This is the basic process of how to use a line graph in our representation. Click a line graph template. Then the chart looks like as given below. For this first select the data table and then go to insert menu under charts select insert line chart as shown below.

Click line with markers. Click the insert tab line chart line. Once we click on the insert line chart icon as shown in the above screenshot we will get the drop down menu of different line chart menu available under it. On the insert tab in the charts group click the line symbol. By doing this excel does not recognize the numbers in column a as a data series and automatically places these numbers on the horizontal category axis.

In the charts group click the insert line or area chart button. Excel creates the line graph and displays it in your worksheet. Click the line graph icon. Excel will tell you which one is which. Only if you have numeric labels empty cell a1 before you create the line chart.

Then open the insert tab in the ribbon. Kasper langmann co founder of spreadsheeto. Open a new excel document. If you forget which button to click just hover over the options. Customizing a line graph.

Other versions of excel. As we can see below it has 2d 3d and more line charts. Click the green insert tab.