Create a chart with recommended charts

Create a chart with recommended charts

Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data.

  1. Select the data for which you want to create a 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

See Also

Available chart types in Office

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

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.