Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
getting an x-value from plotting a y-value | Excel Discussion (Misc queries) | |||
Help with plotting | Charts and Charting in Excel | |||
Plotting a Graph | Excel Discussion (Misc queries) | |||
Excel 2003 xy chart - problem plotting more than 330 points | Charts and Charting in Excel | |||
Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel |