Creating Charts in the Worksheet Cells in Excel 2007:-

In many cases, you don’t need to create a chart in order to visually communicate data. While prior versions of Excel have included features such as slider controls, text bar charts, and conditional formatting to automatically color in certain cells,
Excel 2007 offers three fantastic new data visualization tools under the rewritten conditional formatting logic:

1. Data bars—this tool offers a tiny, in-cell bar chart for each number in a range. The reader’s eye is drawn to the largest numbers because of the size of the bars.

2. Color scales—Color scales, also called heat maps, color cells in a range of colors. You can use one of six built-in schemes where red is high and blue is low, or green is high and red is low, or you can define your own color scheme.

3. Icon sets—you can now add a tiny icon next to each number in a range. Icons can use a traffic light metaphor, power bar metaphor, or arrow metaphors to show which data points are the best performers in a dataset.

With each of these new data visualizations, Excel requires only three clicks to get a result. However, each visualization offers advanced settings that give you finer control.