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.

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

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×