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 "All Charts," choose "Combo" as the chart type, and then select "Clustered Column - Line," which is the default subtype. Choose the type of chart you want to use for each data set in the ...

The Change Chart Type utility in Microsoft Excel features several graphs from which you can select to convert your current Excel chart into a graph.

After that, select a 2-D Line graph that you want to display in your spreadsheet. After inserting the graph, right-click on the blue line, and select the Format Data Series option.

The Sparkline feature, introduced in Excel 2013, lets you select data from rows or columns of cells and display line, column or handy win/loss charts.

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.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

In Microsoft Excel, to draw attention to a specific marker in a line chart, drop in a thin line, think of it as a marker.