| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display sign on a chart
How do you display or < signs on a chart, I am trying to put values on a
chart but some of them are <2 or 60 etc. These values are displayed as zero on the chart. Is it possible to display values with < or signs before the number? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Display sign on a chart
Try using a custom number format.
Go to Format - Cells. On the Number Tab choose Custom from the Category option. Type in: <#,##;#,## -- John Mansfield "Felicity" wrote: How do you display or < signs on a chart, I am trying to put values on a chart but some of them are <2 or 60 etc. These values are displayed as zero on the chart. Is it possible to display values with < or signs before the number? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Display sign on a chart
Hi,
Try this custom number format. [<2]"<"#;[60]""#;0 Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Felicity" wrote in message ... How do you display or < signs on a chart, I am trying to put values on a chart but some of them are <2 or 60 etc. These values are displayed as zero on the chart. Is it possible to display values with < or signs before the number? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Display sign on a chart
Thanks so much John, that worked! Thats been a mystery to me for years, how
do you know how to do that? "John Mansfield" wrote: Try using a custom number format. Go to Format - Cells. On the Number Tab choose Custom from the Category option. Type in: <#,##;#,## -- John Mansfield "Felicity" wrote: How do you display or < signs on a chart, I am trying to put values on a chart but some of them are <2 or 60 etc. These values are displayed as zero on the chart. Is it possible to display values with < or signs before the number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display a cent sign | Excel Discussion (Misc queries) | |||
| How do I not display the Euros sign, if value is 0? | Excel Discussion (Misc queries) | |||
| Formatting: Display a minus sign before a number | Excel Discussion (Misc queries) | |||
| display plus sign on plus numbers in Excel | Excel Discussion (Misc queries) | |||
| I want to display the minus sign | New Users to Excel | |||
Linear Mode
