How do you use Excel to make a line graph?

Click the Insert tab, and then click Insert Line or Area Chart. Click Line with Markers. Click the chart area of the chart to display the Design and Format tabs. Click the Design tab, and then click the chart style you want to use.

How do you create a line graph in Excel?

First things first,select the data needed as shown below.

Go to Insert > Charts > click on the drop-down arrow next to Line Chart and select 2-D Line,Line as shown below.

With the Chart selected,go to Chart Tools > Design > Chart Styles and select Chart Style 2 as shown below,in order to quickly format the chart.

How to make line graph in Excel with multiple lines?

Highlight the cells in the range B1:D8.

Click the Insert Tab along the top ribbon.

In the Charts group,click the first chart option in the section titled Insert Line or Area Chart.

How to make a line graph?

Well imagine your company has a database of quality defects. The database is split by manufacturing line, part number and defect type. The previous table shows how many extrusion lines we have on site.

How to make a line graph in Excel-easy tutorial?

1) Open Microsoft Excel. Double-click the Excel program icon, which resembles a white “X” on a green folder. 2) Click Blank Workbook. It’s on the Excel home page. Doing so will open a new spreadsheet for your data. 3) Enter your data. A line graph requires two axes in order to function. Enter your data into two columns. 4) Select your data. Click and drag your mouse from the top-left cell in the data group to the bottom-right cell in the data group. 5) Click the Insert tab. It’s on the left side of the green ribbon that’s at the top of the Excel window. 6) Click the “Line Graph” icon. It’s the box with several lines drawn on it in the Charts group of options. 7) Select a graph style. Hover your mouse cursor over a line graph template in the drop-down menu to see what it will look like with your data. 8) Click a graph style. Once you decide on a template, clicking it will create your line graph in the middle of the Excel window.