Charts have a big job in Excel because they are used to showcase the data you’re presenting in an graphical, easy-to-understand manner. You can choose from a number of different chart types and then fine-tune the styles within those chart types to get just the effect you need for your data. One of the new features in Excel 2013 is the Recommended Charts tool, which suggests the types of charts that best fit the data you’ve highlighted on the worksheet.
Click a cell in the data that you want to summarize.
Click the Insert tab.
Click the type of chart you want to create in the Charts group.
Click the desired chart subtype.
Using a worksheet on which you’ve entered some data, select cells and ...