View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott from Gippsland
 
Posts: n/a
Default Generating graphs with less than results

I currently export data from a laboratory into excel, and need to generate a
series of graphs based on the data.

Due to the nature of the tests done by the laboratory, certain results are
presented as less than (<00.00).

Is there a simple way of generating graphs when parts of the data have the <
symbol in front of the number?

Hope someone has some ideas