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.
Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

To make complex data and data relationships easier to understand, create a chart to display the data visually.

  1. Select the place in the document where you want to insert the chart.

  2. Select Insert > Chart.

  3. Select the type of chart you want, and then select OK.

  4. In the spreadsheet, enter your data.

Want more?

Available chart types in Office

Add a chart to your document in Word

Word training

PowerPoint training

Excel training

To visualize complex data in an Office file, insert a chart.

If you’d like to create a chart in PowerPoint or Word, select Insert > Chart.

The default is a Column, but you have different options to choose from.

We’ll select Column for now and then select OK.

Now change the placeholder data with your own.

We’ll fill in our categories and the new names automatically appear in the chart as they’re typed in.

For the series, add headings—this might be a name that describes what each group of data is.

Now, enter your data.

As you move across cells, the chart updates to show the new values entered.

Finish entering your data, and then select Close.

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!