Use color scales to make the temperature chart

Uploaded time: October 22, 2021 Difficulty: Primary

Use color scales to make the temperature chart

Use color scales to make the temperature chart

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_2.gif


At this time, the selected table area will be marked with color. The higher the temperature, the deeper the red; the lower the temperature, the deeper the blue.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.