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?

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?

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?

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?