You can use these buttons and their drop-down menus to create these types and styles of charts. To the right of the Recommended Charts button on the ribbon, you'll see this: We'll discuss all of these options later in this article. The tools shown above will help you customize your charts. You'll also notice the Chart Tools Format tab opens in the Ribbon: The chart is embedded in your worksheet for you: On the right is a preview of what the chart will look like with your data.Ĭhoose the chart you want to use, then click OK.

On the left side of this dialog box you'll find all the chart recommendations. When you click on the Recommended Charts button, a dialog box opens, like the one pictured below.īased on your data, Excel recommends a chart for you to use. To create a chart this way, first select the data you want to put into a chart. This is under the Insert tab on the Ribbon in the Charts group (as pictured above).

That was a great tool and a great help, but Excel 2013 offers you something even better: the Recommended Charts tool. In prior versions of Excel, you had the Chart Wizard to help you create charts.

How to make a pie chart in excel 2013