Microsoft Office Tutorials and References
In Depth Information
Using formulas to display repeating characters
Notice that the formula divides the value in column B by 2. This is a way to scale the chart. Instead of
displaying 60 asterisks, the cell displays 30 asterisks. For improved accuracy, you can use the ROUND
function:
=REPT(“*”,ROUND(C3/2,0))
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 B 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 94-3 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 D39 is
=REPT(“|”,C39/2000)
Figure 94-3: Examples of in-cell charting using the REPT function.
Search JabSto ::




Custom Search