Include data bar in Excel Data to Quickly review the strength individually.

Add caption
Data Bar in Excel conditional formatting is to use visually compare instant result quickly, suppose there is an unsorted data of sales record but there is no sequence found , so now its time to use data bar to visually indicate by filling colors are which is the maximum and minimum value in that column or row !


simple rule is the higher color filled higher value lower filled showing lower values.



Typically data bar is used to upper and lower value in the selected column quickly.
Two Types in Data Bar

Gradient fill : 
filled with soft colors as maximum in increase minimum in decrease 
Short Key of Data Bar is Alt, H, L, D
Solid fill :
filled with full solid color to same above.




No comments:

Post a Comment