Okay, here is the offending code section:
run.section(Standard,NewWks);
%B = %H;
window -r %B percCirc;
percCirc_PopulationStats = Bin2_PopulationStats;
percCirc_Value = (Bin2_Counts1/%(statsOnDOrig,22,1))*100;
worksheet -s 1 0 2 0; // select all rows in columns 1 and 2
run.section(Plot,Column);
label -p 80 1 -s -n nval \b(%(statsOnDOrig,22,1));
label -p 75 1 -s -n nlab "\b(N=)";
label -r legend;
layer1.x.label.divideby = 1;
layer1.x.from = 0;
layer1.x.inc = 0.1;
layer1.x.to = 1.1;
layer.x.showgrids = 1;
layer.y.showgrids = 1;
second -p 1;
layer1.x.grid.majorColor = 1;
layer1.y.grid.majorColor = 1;
// might stop here
second -p 1;
set percCirc_Value -pfc 1; // set column pattern foreground colour
set percCirc_Value -pbc 1; // set column pattern background colour
set percCirc_Value -pfp 0; // set column fill pattern
set percCirc_Value -pfb 12; // set column background colour
set percCirc_Value -cf 12; // set fill colour
layer.y.color = 1;
layer1.x.inc = 0.1;
label -n XB \b(\p120(Particle shape (profile circularity)));
label -n YL \b(\p110(\c12(Particle frequency (percentage by number))));
%A = %(sheet1,10,1); //get contents of excel cell
%P = %[%A, 1:((%[%A]-3)/2)-20]; //get user text
%Q = %[%A, %[%A]-7:%[%A]]; //get session time
label -d 450 200 -s \b(\p120(\c14(\p144(Shape (circularity) - )%P - %Q)));
%B = %H;
window -r %B percCircHist;
I think it stops around the point where I have included the comment "//might stop here" but I cannot see any reason why. Can anyone shed some light on why this block of code might not work? Or give the desired result? (Which is a graph to the right scale)
Edited by - psgst on 11/22/2006 09:07:52 AM
Copying a column from one worksheet to another
Posted - 11/21/2006 : 05:56:09 AM
