Microsoft Office Tutorials and References
In Depth Information
Creating a Text Chart Directly in a Range
Without the ROUND function, the formula truncates the result of the division (disregards the
decimal part of the argument). For example, the value 67 in column C displays 33 characters in
column D. Using ROUND rounds up the result to 34 characters.
You can use this type of graphical display in place of a column chart. As long as you don’t require
strict accuracy (because of rounding errors), this type of nonchart might fit the bill.
Figure 133-2 shows some other examples that use different characters and fonts. The chart that
displays the solid bars (beginning in row 39) uses the pipe character of the Script font. On most
keyboards, the pipe character is generated when you press Shift+Backslash. The formula in cell
Figure 133-2: Examples of in-cell charting using the REPT function.