Display > sign on a chart

[Felicity]

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?

 

[John Mansfield]

Try using a custom number format.

Go to Format -> Cells. On the Number Tab choose Custom from the Category
option. Type in:

<#,##;>#,##

 

[Andy Pope]

Hi,

Try this custom number format.

[<2]"<"#;[>60]">"#;0

Cheers
Andy

 

[Felicity]

Thanks so much John, that worked! Thats been a mystery to me for years, how
do you know how to do that?