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

Create a chart

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Create a chart (graph) that is recommended for your data, almost as fast as using the chart wizard that is no longer available.

Create a chart

  1. Select the data for which you want to create a chart.

  2. Click INSERT > Recommended Charts.

  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.

    If you donโ€™t see a chart you like, click All Charts to see all the 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 is shown in the 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.

Want more?

Copy an Excel chart to another Office program

Create a chart from start to finish

Charts provide a visual representation of your data, making it easier to analyze.

For example, I want to create a chart for Sales, to see if there is a pattern.

I select the cells that I want to use for the chart, click the Quick Analysis button, and click the CHARTS tab.

Excel displays recommended charts based on the data in the cells selected.

You can hover over each one to see what looks good for your data.

Clustered Column is great for comparing data, so I click it.

And now, I have an eye catching chart of the data.

It looks like the Summer months are slower and the Winter months are busier.

Up next, Create pie, bar, and line charts.

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?

Thank you for your feedback!