| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
In a chart, how do you put a $ on the top value axis?
In a bar chart, how do you put a dollar sign on only the top value axis in
Excel? What is the formula? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
In a chart, how do you put a $ on the top value axis?
Click the chart; in the Formula bar type a $; more the resulting textbox to
required position best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "JudyF" wrote in message ... In a bar chart, how do you put a dollar sign on only the top value axis in Excel? What is the formula? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
In a chart, how do you put a $ on the top value axis?
You need a custom number format. Suppose the maximum is 2000, double click
the axis, and on the Number tab of the dialog, enter this custom format: [=2000]$#,##0;#,##0 Unfortunately this is not dynamic; if the maximum changes to 5000 or 500 your $ will disappear. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "JudyF" wrote in message ... In a bar chart, how do you put a dollar sign on only the top value axis in Excel? What is the formula? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
In a chart, how do you put a $ on the top value axis?
Thanks a lot, Jon you were very helpful. This will help in future charts as
well. "Jon Peltier" wrote: You need a custom number format. Suppose the maximum is 2000, double click the axis, and on the Number tab of the dialog, enter this custom format: [=2000]$#,##0;#,##0 Unfortunately this is not dynamic; if the maximum changes to 5000 or 500 your $ will disappear. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "JudyF" wrote in message ... In a bar chart, how do you put a dollar sign on only the top value axis in Excel? What is the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
| Line Chart Axis Reversal | Charts and Charting in Excel | |||
| Date X axis Affect Bar Width in a Bar Chart | Charts and Charting in Excel | |||
| Chart Axis Value | Charts and Charting in Excel | |||
| XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
Linear Mode
