Switch to Excel for Windows from Sheets

Analyze data

Analyze data with Excel for Windows

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

Expand your Office 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.

×