
IN THIS CHAPTER
Presenting Data Visually
Without Charts
9
Creating Charts in the Worksheet
Cells
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 visualiza-
tion tools under the rewritten conditional format-
ting logic:
■ 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.
■ Color scales—Color scales, also called ...