LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
getting an x-value from plotting a y-value Moni Excel Discussion (Misc queries) 9 April 9th 07 02:20 PM
Help with plotting Chris Clarke Charts and Charting in Excel 1 September 5th 06 08:01 PM
Plotting a Graph Mayank Excel Discussion (Misc queries) 2 June 9th 06 08:12 PM
Excel 2003 xy chart - problem plotting more than 330 points ehmcneill Charts and Charting in Excel 1 December 17th 05 12:18 AM
Problem with plotting a chart when using arrays as Values and Xvalues [email protected] Charts and Charting in Excel 3 August 19th 05 09:05 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"