Create a chart with recommended charts
Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

If you're exploring charts in Excel and having a hard time figuring out which one is right for you, then you can try the Recommended Charts command on the Insert tab. Excel will analyze your data and make suggestions for you.

  1. Select the data you want to use for your chart.

  2. Click Insert > Recommended Charts.

    Charts group on the Insert tab

  3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.

    Recommended Charts tab in the Insert Chart dialog box

    Tip: If you don’t see a chart you like, click All Charts to see all available chart types.

  4. When you find the chart you like, click it > OK.

  5. Use the Chart Elements, Chart 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.

    Recommended stacked column chart

  6. To access 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.

    Design and Format tabs for the Chart Tools

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Available chart types in Office

Get Microsoft chart templates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.