Excel charts
 

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

Excel charts
 

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?

Excel charts
 

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?

Excel charts
 

Sorry I misunderstood yr question. If you just want a $ sign before the
values, right click the axis and choose the appropriate number format on the
number tab. But if you want ONLY the top value it can only be done with an
arbitrary axis, I think. Possibly Jon Peltier's website provides what you
want: http://www.peltiertech.com/Excel/Cha...traryAxis.html
HTH,
Henk

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

Excel charts
 

Hi,

For an axis that has a maximum of 100 with steps of 10.

[<91]#,##0.00;[90]£#,##0.00

Cheers
Andy

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

Excel charts
 

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

Excel charts
 

Thank you so much for that website. I was able to figure it out. Here is a
sample of the code: [=60]$#,##0;[<=50]#,##0;General. This would be based on
a scale where the maximum is 60 and the minimum is 0.

"HEK" wrote:

Sorry I misunderstood yr question. If you just want a $ sign before the
values, right click the axis and choose the appropriate number format on the
number tab. But if you want ONLY the top value it can only be done with an
arbitrary axis, I think. Possibly Jon Peltier's website provides what you
want: http://www.peltiertech.com/Excel/Cha...traryAxis.html
HTH,
Henk

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

Excel charts
 

Nice, Andy. I didn't know that one.
Henk

"Andy Pope" wrote:

Hi,

For an axis that has a maximum of 100 with steps of 10.

[<91]#,##0.00;[90]£#,##0.00

Cheers
Andy

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