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.

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

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.

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.

To generate the chart, select the data, click the Insert tab, click the Line option in the Charts group, and select the first (and simplest) option. In Excel 2003, choose Chart from the Insert menu.

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