Another option is to use the Display Units on the Scale tab. The
built-in options are Hundreds, Thousands, etc. But once displayed you
can edit the text or even link the title box to a cell.


mvgfrwd wrote:
I'm sorry, but that's not the answer I'm seeking. There's a way to create a
custom code in the number format window. A former coworker knew how to create
it, but I have since forgotten.

"HEK" wrote:


Put the "$" sign in your value axis title which you can define during the
chart wizard. By default it appears in the middle of the chart, but
effectively it is in a text box that you can move to the top. Right-clicking
it in the chart allows you to change text direction and perform other
formatting.
Hope this is what you seek.
Br,
Henk

"mvgfrwd" wrote:


How do I get the dollar sign to appear on the top number of the value axis
only?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info