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 |
|
|