The recommended charts button was added in Excel 2013. It provides access to more than 150 professionally design charts and, in general, it’s a good way to create new charts in later versions of Excel. The charts are good looking and in most cases they fit the data pretty well. To create a new chart in Excel with recommended charts, just select the data then the Recommended Charts button on the Insert tab of the ribbon. Excel will open the Insert Chart window with a list of thumbnails on the left, and larger live previews to the right. This list represents the chart types Excel recommends, based on the data you’ve selected. Notice the Insert Chart window has two tabs. The first tab is “Recommended charts” and the second tab is “All charts”. The All Charts tab allows you to see every chart option available, not just recommended charts. It also has links to recent charts and any saved chart templates. When you find the chart you want, select the thumbnail and click OK. Excel will create the chart on your worksheet. If you know in advance what kind of chart type you want, you can also use the small icons to the right of the Recommended chart button. This will save you a little time. Like Recommended Charts, these buttons also provide live previews. When you hover over an icon, Excel will build a preview directly on the worksheet below. Just click to insert the chart. If you select an existing chart, and then click the Recommended Charts button, Excel will open a window with Change Chart Type as the title. If you select a different chart type, Excel will change the type of the existing chart instead of inserting a new chart. You’ll see exactly this same behavior if you click the Change chart type button directly. If you’re working on Windows, you can use a ribbon shortcut to insert a recommended chart. Select the data, then type: Alt + N + R  

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.