How do I get the dollar sign to appear on the top number of the value axis
only?
How do I get the dollar sign to appear on the top number of the value axis
only?
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?
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?
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?
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
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
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?
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks