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
 All Forums
 Origin Forum
 Origin Forum
 ignoring text cells in "line+symbol" plots

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
OndrejMM Posted - 07/13/2009 : 11:38:22 PM
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?
2   L A T E S T    R E P L I E S    (Newest First)
OndrejMM Posted - 07/16/2009 : 10:11:37 PM
that was easy,... thanks a lot,...
cheers, ondrej
Laurie Posted - 07/14/2009 : 3:39:05 PM
Select Format:Page, to open the Plot Details dialog. On the Display tab, check the Connect line across Missing Data checkbox.

OriginLab Technical Support

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000