10% of higher values
Bottom 10
10% of lower values
Above average
Below average
For the Top 10 and Bottom 10 options search phone number philippines you can choose the number of items you want to highlight. For the Top 10% and Bottom 10% options , you can choose the desired percentage.
Data bars
“ Data bars ” are the third relationship. These allow you to visually compare the value of a cell to other cells. The largest bar represents the highest value and the smallest represents the lowest value. This type of rule is useful for finding the highest and lowest values, especially when you have to analyze large amounts of data.
The only difference between the various options presented are the colors and effects of the bars.
Data bar
You can see this example of the final result of the data bar:
Data bar table
Color scales
Continuing down the list we have the “ color scales ” which allow you to visually perceive the distribution of data through colors. You can choose scales of 2 or 3 colors.
The options shown to us only differ in the colors we want to choose.