Customizing Data Bars in Excel 2007:-


By default, Excel assigns the largest data bar to the cell with the largest value and the smallest data bar to the cell with the smallest value. You can customize this behavior by following these steps:

1. From the Conditional Formatting drop-down on the Home ribbon, choose Manage Rules.

2. From the Show Formatting Rules drop-down, choose This Worksheet. You now see a list of all rules applied to the sheet.

3. Click the Data Bar rule.

4. Click the Edit Rule button. You see the Edit Formatting Rule dialog, as shown in the first Figure (given below).



(You customize data bars by using the Edit Formatting Rule dialog.)

5. To change the color of the data bars beyond the six basic colors, choose the Bar Color drop-down and then choose from the theme colors or standard colors or click More Colors to build any RGB value you like.

6. Select the Show Bar Only check box. Excel hides the numbers in the cells and shows only the data bars. This is an interesting variation, as shown in the second Figure (given below).



(Showing only the data bars is an interesting alternative.)