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 make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.

Pie charts are used to show percentages of the whole, and Line charts excel with data trends. The remaining chart designs include Area, Stock, Surface, Combo, Pareto, Histogram, and Sunburst.

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.

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.

Want to know how to create a scatter plot in Excel? Here's a guide on how we created a simple chart based on performance numbers.

How to Title on a Line Graph in Microsoft Excel. Microsoft Excel doesn't always provide everything you need when it generates graphs. For example, by default, your line graph doesn't included a title.

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.