Hi dddang,
If your X columns contain text, even when your Y data is missing, bars are arranged at the row indices: 1,2,... .
So, you have to extract data not to include missing values in the Y column by Worksheet Query tool (under Worksheet menu).
When your Y column is B, you can enter COL(B)!=0/0 in the Condition box. (0/0 means a missing value.)
(Or, you can enter the following x-function in the Script window:
wextract -r 1 settings.stCondition.Condition:="COL(B)!=0/0" settings.Cols:="0|1" oy:=[%H]<new>;
Here, the option "-r 1" sets the recalculation mode to Auto, and "Cols" are extracted columns - the column# starts from 0, not 1.)
You can make a column graph from the extracted worksheet.
Hope this helps.
--Hideo Fujii
OriginLab
how can i auto skip empt data column
Posted - 12/15/2016 : 04:15:49 AM
