You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Select the two sets of data you want to use to create the graph. Choose the "Insert" tab, and then select "Recommended Charts" in the Charts group.

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.

Learn how to demonstrate your marketing data using sexy combination charts in Excel, with tutorials for PC (2013 and Mac (2011).

Launch Excel and open the spreadsheet with the chart you want to edit. Click to select the chart on which you want to highlight the intervals.