Table of contents
×
Switch to Excel for Windows from Sheets
Switch to Excel for Windows from Sheets

Analyze data

Create a chart

Use the Quick Analysis tool to pick the right chart for your data.

  1. Select the data you want to show in a chart.

  2. Select the Quick Analysis button button image to the bottom-right of the selected cells.

  3. Select Charts, hover over the options, and pick the chart you want.

Try it!    Select File > New, select Take a tour, and then select the Chart Tab. For more information, see Create charts.

Charting with Quick Analysis

Use conditional formatting

Use Quick Analysis to highlight important data or show data trends.

  1. Select the data to conditionally format.

  2. Select the Quick Analysis button button image to the bottom-right of the selected cells.

  3. Select Formatting, hover over the options, and pick the one you want.

Try it!    Select File > New, select Take a tour, and then select the Analyze Tab.

Using Quick Analysis to highlight data

Next: Tips for Excel for Windows

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!

×