Display > sign on a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try using a custom number format.

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

<#,##;>#,##
 
Thanks so much John, that worked! Thats been a mystery to me for years, how
do you know how to do that?
 
Back
Top