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

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?
 
B

Bernard Liengme

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

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
On a column chart, how do you put a percent sign on the top most . 2
Plot value at top of chart 1
vertical scale on both ends of bar chart 1
Extending The Horiz. Axis Question ? 1
Move x axis to the top of a 3D horizontal bar chart 1
Positioning x axis at bottom of chart with negative values 5
Make Y-axis values correspond to x- axis value 1

Top