ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   problem with plotting (https://www.excelbanter.com/excel-discussion-misc-queries/135754-problem-plotting.html)

roger

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


dlw

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



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