Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel charts
How do I get the dollar sign to appear on the top number of the value axis
only? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically resize excel charts when exporting them to PowerPoin | Charts and Charting in Excel | |||
How to copy & paste excel charts to Words as Windows Metafile | Charts and Charting in Excel | |||
How do I create new default color settings for charts in Excel? | Charts and Charting in Excel | |||
Excel should heavily extend the options for black-white charts | Charts and Charting in Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |