In a chart, how do you put a $ on the top value axis?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?
 
Click the chart; in the Formula bar type a $; more the resulting textbox to
required position
best wishes
 
You need a custom number format. Suppose the maximum is 2000, double click
the axis, and on the Number tab of the dialog, enter this custom format:

[=2000]$#,##0;#,##0

Unfortunately this is not dynamic; if the maximum changes to 5000 or 500
your $ will disappear.

- Jon
 
Thanks a lot, Jon you were very helpful. This will help in future charts as
well.

Jon Peltier said:
You need a custom number format. Suppose the maximum is 2000, double click
the axis, and on the Number tab of the dialog, enter this custom format:

[=2000]$#,##0;#,##0

Unfortunately this is not dynamic; if the maximum changes to 5000 or 500
your $ will disappear.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


JudyF said:
In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?
Click to expand...
Click to expand...
 
Back
Top