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:

<#,##;>#,##
 
Hi,

Try this custom number format.

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

Cheers
Andy
 
Thanks so much John, that worked! Thats been a mystery to me for years, how
do you know how to do that?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zero values as gap in a chart 1
Macro to change position of chart labels on line chart 1
How to create a bubble chart with more than 2 variables 0
Displaying cell data in a chart 3
Non-number value in Charts 5
Displaying content of a cell somewhere on the chart 1
Excel 2007 Pivot charts, any way to display filters on the chart? 1
Inside Base Series Label Showing #N/A 0

Back
Top