View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roger roger is offline
external usenet poster
 
Posts: 8
Default problem with plotting

Hi,
I am trying to plot a data which have some text in it. Is there any
possibility to ignore these text and plot the numbers as whenever I
try to plot it takes an automatic value of zero.

my data read something like this:

31,1 mg/l 0,003 mg/l
30,3 mg/l 0,096 mg/l
30,9 mg/l 0,033 mg/l
26,7 mg/l 0,090 mg/l
20,3 mg/l 3,7 mg/l

plz help me.
Thanks in advance
Roger