molecule

Using Data Bars to Create In-Cell Bar Charts in Excel 2007:-

A data bar is a semitransparent swath of color that starts at the left edge of a cell. The smallest numbers in a formatted range have just a tiny bit of color in the cell. The largest numbers in the formatted range are 90% filled with color. This creates a visual effect that enables you to visually pick out the larger and smaller values.

Creating data bars requires just a few clicks. You follow these steps:

1. Select a range of numeric data. Do not include the total in this selection. If the data is in noncontiguous ranges, hold down the Ctrl key while selecting additional areas. This range should be numbers of similar scale. For example, you can select a column of sales data or a column of profit data. If you attempt to select a range that contains both units sold and revenue dollars, the size of the revenue numbers will overpower the units sold numbers, and no color will appear in the units sold cells.

2. From the Home ribbon, select Conditional Formatting, Data Bars. You see six built-in colors for the data bars: blue, green, red, orange, bright blue, and pink. Select one of them.

The result is a swath of color in each cell in the selection, as shown in the Figure (given below).



(After applying a data bar, you can easily see that California is a leading exporter of agriculture products.)