Excel charts

[mvgfrwd]

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

 

[HEK]

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]

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]

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/Charts/ArbitraryAxis.html
HTH,
Henk

 

[Andy Pope]

Hi,

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

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

Cheers
Andy

 

[Andy Pope]

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]

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]

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

Hi,

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

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

Cheers
Andy

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.

: