Create a chart with recommended charts

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.

Animation of a blank worksheet showing Insert > Recommended Charts > clicking Try sample data from the recommended charts pane, then clicking + Insert Pivot Chart on the first chart displayed.

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 ProPlus.

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, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Available chart types in Office

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×