The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 ignoring text cells in "line+symbol" plots		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

OndrejMM

Australia
81 Posts
Posted - 07/13/2009 :  11:38:22 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi,

how can I ignore “No Value” cells when plotting? My data looks like this:


0 7.68284 -1.08761 150.515 0.00879 35.4849
0.52 28.2234 -3.26151 203.565 0.00976 NoValue
0.59 NoValue NoValue NoValue NoValue 55.6667
0.6 NoValue NoValue NoValue NoValue NoValue
1.03 48.9367 -5.48277 257.146 0.01076 NoValue
1.19 NoValue NoValue NoValue NoValue 76.1906
1.2 NoValue NoValue NoValue NoValue NoValue
1.55 148.33 -3.38433 375.321 0.02691 NoValue
1.78 NoValue NoValue NoValue NoValue 158.546
1.8 NoValue NoValue NoValue NoValue NoValue
2.06 166.3 0.88218 389.793 0.03674 NoValue
2.37 NoValue NoValue NoValue NoValue 171.068
2.4 NoValue NoValue NoValue NoValue NoValue
2.58 176.303 6.07689 390.279 0.04386 NoValue
2.97 NoValue NoValue NoValue NoValue 177.421
3 NoValue NoValue NoValue NoValue NoValue
3.09 179.476 11.2706 380.97 0.04765 NoValue
3.56 NoValue NoValue NoValue NoValue 177.013
3.6 164.394 14.591 351.159 0.03939 NoValue

so there is lot of “NoVolue” cells but I need to do the “Line+Symbol” plot type but of course it doesn’t work because of those text cells and eventually I’m getting just “scetter” plot,… can I somehow ignore this text cells without deleting them?

Laurie

USA
404 Posts
Posted - 07/14/2009 :  3:39:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Select Format:Page, to open the Plot Details dialog. On the Display tab, check the Connect line across Missing Data checkbox.

OriginLab Technical Support
Go to Top of Page

OndrejMM

Australia
81 Posts
Posted - 07/16/2009 :  10:11:37 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
that was easy,... thanks a lot,...
cheers, ondrej
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000