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
-
Select the data for which you want to create a chart.
-
Click INSERT > Recommended Charts.
-
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.
-
When you find the chart you like, click it > OK.
-
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.
-
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?
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.
