Microsoft Office Tutorials and References
In Depth Information
Tip 94: Creating a Chart Directly in a Range
Creating a Chart Directly in a Range
This tip describes two ways to display a bar chart directly in a range of cells:
➤ Using conditional formatting data bars
➤ Using formulas that display repeating characters
These “non-chart” charts often serve as a quick way to display lots of data graphically, without
creating actual charts.
Using conditional formatting data bars
Using the data bars conditional formatting option can sometimes serve as a quick alternative to
creating a chart. The data bars conditional format displays horizontal bars directly in the cell. The length
of the bar is based on the value of the cell, relative to the other values in the range. When you adjust
the column width, the bar lengths adjust accordingly. The differences among the bar lengths are
more prominent when the column is wider.
Figure 94-1 shows results from a survey, using data bars to visualize the distribution for each survey
Figure 94-1: These tables use data bars conditional formatting.