Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Create a chart with recommended charts

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

  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

Recommended charts in Excel for the web creates interesting visuals about your data in a task pane.

Recommended Chart

Note: Recommended charts are available to Microsoft 365 subscribers in English, French, Spanish, German, Simplified Chinese, and Japanese. If you are a Microsoft 365 subscriber, make sure you have the latest version of Office. To learn more about the different update channels for Office, see: Overview of update channels for Microsoft 365 Apps.

Get started

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

  2. Click Insert > Recommended Charts.

  3. Choose a chart to insert from the Recommended Charts task pane, and select the + Insert Pivot Chart or + Insert Chart option.

  4. If you choose the Pivot chart option, then Excel will insert a new worksheet for you with a PivotTable that is the data source for the Pivot Chart you selected. Each time you use the Insert Pivot Chart option, Excel will insert a new worksheet. If you choose the Insert Chart option, Excel will insert a chart directly on the worksheet with your source data.

    Recommended PivotTable and Pivot Chart added to a newly inserted worksheet.

Not sure how to get started?

If you're not sure how to get started, we'll give you some sample data you can experiment with.

  1. Add a new worksheet -- You can right-click on any sheet tab, then select Insert.

  2. Go to Insert > Recommended Charts, and Excel will load the Recommended Charts pane.

  3. Select the Try sample data button.

    Excel Recommended Charts pane when no data is present in the worksheet. Select the Try sample data to automatically add a sample dataset to your worksheet.

    Excel will add some sample data to your worksheet, analyze it, then add recommended charts to the pane.

  4. Follow the steps in the Get Started section to insert any of the recommended Pivot Charts or charts.

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.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×