Analyze data with Excel for Windows
Create a chart
Use the Quick Analysis tool to pick the right chart for your data.
-
Select the data you want to show in a chart.
-
Select the Quick Analysis button
to the bottom-right of the selected cells. -
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](https://support.content.office.net/en-us/media/808718a4-fac7-4388-9088-96f506e196c0.png)
Use conditional formatting
Use Quick Analysis to highlight important data or show data trends.
-
Select the data to conditionally format.
-
Select the Quick Analysis button
to the bottom-right of the selected cells. -
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](https://support.content.office.net/en-us/media/fc487b6e-a096-48cf-8bef-afaf0d1ac67c.png)