Recommended Charts will recommends the most suitable charts for your data.  You can get a quick view to see how your data looks in the different charts.

Create a chart

  1. Select the data for which you want to create a chart.
  2. Click Insert > Recommended Charts.
  3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and then click any charts to see how your data look like using this chart.  If you do not see a chart you like, click All Charts to see all available chart types.
  4. After you find the chart you like, click it and then click OK.
  5. Use the Chart ElementsChart Styles, and Chart Filters buttons next to the upper-right corner of the chart to add chart elements like axis titles or data labels, customize the look of your chart, or change the data that’s shown in the chart.
  6. To add more additional design and formatting features, click anywhere in the chart to add the Chart Tools to the ribbon, and then click the options you want on the Design and Format tabs.