problem with plotting

  • Thread starter Thread starter roger
  • Start date Start date
R

roger

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
 
if you do edit/replace, and replace mg/l with nothing, it will make them
numbers instead of 0
 
if you do edit/replace, and replace mg/l with nothing, it will make them
numbers instead of 0

Thanx for the reply
but the point is... I want those text to be there without replacing.
is there any other way to do it?
thanx
 

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

Sumproduct problems... 4
Not plotting null or text data 2
Pareto/Bar charts 3
Problem with plot 2
problems with scatter plot 2
Stacked Bar Chart 1
Plotting Null's 1
Scatter plot and line graph combination 2

Back
Top