Video: Create charts

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

Try it!

Charts help you visualize your data in a way that creates maximum impact on your audience. Learn to create a chart and add a trendline.

Create a chart

  1. Select the data for your chart.

  2. Select Insert > Recommended Charts.

  3. Select a chart on the Recommended Charts tab, to preview the chart.

    Note: You can select the data you want in your chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. If you don’t see a chart you like, select the All Charts tab to see all chart types.

  4. Select a chart.

  5. Select OK.

Add a trendline

  1. Select a chart.

  2. Select Design > Add Chart Element.

  3. Select Trendline and then select the type of trendline you want, such as Linear, Exponential, Linear Forecast, or Moving Average.

Want more?

Create a chart in Excel 2016 for Windows

Available chart types in Office

Add a trend or moving average line to a chart

Discover more Excel training at LinkedIn Learning

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