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

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

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

Click the chart; in the Formula bar type a $; more the resulting textbox to
required position
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

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

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" wrote in message
...
In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?

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

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

"Jon Peltier" wrote:

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" wrote in message
...
In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula?