Excel data bar: YOUR OBJECTIVE
In this learning module “ excel data bar ” you will learn how to visually highlight cells using data bars and what you have to pay attention to.
HOW DOES EXCEL DATA BAR WORK?
The extensive Conditional Formatting and the option to visually highlight and analyze cells with data bars is new to Excel. The length of a data bar corresponds to the value of the cell. This type of Conditional Formatting is particularly useful when you want to analyze values where the relationship of the values to each other is more important than the values themselves.
To add data bars to the cells of a data range, select the data range first:
A submenu containing twelve different design options opens:
Click on the option you want to apply to the cells. The length of the data bar corresponds to the value in the cell. A long bar represents a high value, a short bar represents a low value:
You can of course also delete a Conditional Formatting. Click the Conditional Formatting button on the Home tab and select the Clear Rules command.
Previous Excel versions do not support this Conditional Formatting feature. Excel data bars are not displayed when you open the file with a previous Excel version in the compatibility mode.