![]() |
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 |
problem with plotting
if you do edit/replace, and replace mg/l with nothing, it will make them
numbers instead of 0 "roger" wrote: 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 |
problem with plotting
On Mar 21, 5:31 pm, dlw wrote:
if you do edit/replace, and replace mg/l with nothing, it will make them numbers instead of 0 "roger" wrote: 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 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 |
All times are GMT +1. The time now is 06:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com