Create a chart

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

Tip:  If you’re using Office Professional Plus, you can also use Power View to create a chart. For more about Power View, see Charts and other visualizations in Power View.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!