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

[JudyF]

In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?

 

[Bernard Liengme]

Click the chart; in the Formula bar type a $; more the resulting textbox to
required position
best wishes

 

[Jon Peltier]

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

 

[JudyF]

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

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
_______

In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?