Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Use color scales to make the temperature chart
Uploaded time: October 22, 2021 Difficulty Beginner
Use color scales to make the temperature chart
![](http://res-academy.cache.wpscdn.com/static/cover/big_xls.png)
Use color scales to make the temperature chart
The table shows the minimum temperature data of each month in a specific area. We can visually display the temperature changes through the color scale feature of the conditional formatting.
We select the cell range B2:M2 and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the Color Scales option. In the pop-up menu, we can select Red-White-Bule Color Scale.
At this time, the selected table area will be marked with color. The higher the temperature, the deeper the red; the lower thetemperature, the deeper the blue.
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Also Read:
Does this video help you?