Microsoft Office Tutorials and References
In Depth Information
Unit-of-Measure Text Boxes
Look again at the text box that
shows the unit of measure for the Y
axis. Newspapers and magazines
use this type of label extensively,
and it works well with Excel.
This text box takes up very little
space, particularly because it uses
a smaller font than the rest of the
chart. Even so, it’s very readable. In
fact it’s much more readable and
takes up much less space than Excel’s default Y-axis label.
▲T ho usand $
To insert the arrow symbol in the unit-of-measure label, select the
edit area of the text box. Choose Insert, Symbol. Then choose the
symbol you want.
In dashboards, the unit-of-measure text often will be dynamic, for at
least two reasons. First, you can specifiy the power of ten. Second,
you can specify the currency symbol.
Dynamic Power-of-Ten Text
It’s common for one report to round a dataset to the nearest
thousand in a chart and another report to round to the nearest
million. In manual charts we typically shift the decimal place by
using number formats.
To illustrate, if the raw number is 1234567.89:
We round to 1,234.6 with number format: #,##0.0,
We round to 1.2 with number format: #,##0.0,,
The difference between these formats isn’t obvious. One ends with
one comma; the other ends with two commas.