G
Guest
How do I get the dollar sign to appear on the top number of the value axis
only?
only?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
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.
custom code in the number format window. A former coworker knew how to create
it, but I have since forgotten.
G
Guest
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
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
A
Andy Pope
Hi,
For an axis that has a maximum of 100 with steps of 10.
[<91]#,##0.00;[>90]£#,##0.00
Cheers
Andy
For an axis that has a maximum of 100 with steps of 10.
[<91]#,##0.00;[>90]£#,##0.00
Cheers
Andy
A
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.
built-in options are Hundreds, Thousands, etc. But once displayed you
can edit the text or even link the title box to a cell.
G
Guest
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.
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.
G
Guest
Nice, Andy. I didn't know that one.
Henk
Henk
Andy Pope said: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.
: