This article will present when to apply a color scale to your data.
What is a color scale?
A color scale is a way to present your data with a slight difference of color in the function of the values.
Using the color scales option makes sense only if you have a range of cells with many values and highlight an area.
How to use the Color Scales option
- Select your data
- Activate the menu Conditional Formatting > Color Scales
Automatically, the colors of the cells highlight the ''map" between the highest and lowest value.
In function of the values, the highest value is red, and the lowest is green.
If your data are not in connection, the color scales won't help you to visualize the scalability of your data 😕😟
In this situation, it's better to use the bars.