Microsoft Office Tutorials and References
In Depth Information
Now that we’ve set up the data to display efficiently in the chart,
you need to provide the unit of measure for your readers. To do so,
use a simple formula like this in a convenient cell:
=”▲” & IF(Switch=.001, “Thousand”, “Million”) & “ $”
Unfortunately, Excel doesn’t give text boxes the power to use
formulas like this directly. Instead, you need to enter the formula in
a cell and then reference it from the text box.
Dynamic Currency Symbol
It’s easy to display the correct currency symbol in a chart, if there’s
some way for a formula in your workbook to know which currency it
contains. To illustrate, if the cell named Currency contains 1 for $, 2
for €, and 3 for £, your formula could be:
=”▲” & IF(Switch=.001, “Thousand”, “Million”) & “ ” &
CHOOSE(Currency, “$”, “€”, “£”)
Search JabSto ::

Custom Search