This lets you preview data as a 2-D or 3-D line chart. With this, you can preview data as a 2-D stock chart that uses typical stock symbols, a 2-D or 3-D surface chart, or even a 3-D radar chart.

Insert Bar Chart allows you to preview your data as a 2-D or 3-D horizontal bar chart. With this, you can preview data as a 2-D or 3-D vertical column chart. This is the first button, located in the top left corner. We're going to go from left to right, starting at the top left, and cover all the buttons above.

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 use pivot charts in excel 2013