Table of contents
×
Charts
Charts

Create charts

Your browser does not support video.

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 for Windows

Available chart types in Office

Add a trend or moving average line to a chart

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×