Hi, I want to create a script, that creates me a new graph for all the columns I have in my sheet. I have around 10 columns and the first column should be the X and then Y should be the next 9 columns (1-2-3-5...9) . My code is unable to do this, and also I am unable to specifi the numebr of columns nor to see if my FOR gets the correct dataset.
range rSheet = $(page.active)!; range rPage = rSheet.GetPage()$; for( ii = 1 ; ii < int(rSheet.NCOLS) ; ii += 2 ) { plotxy [%(rPage.name$)]%(rSheet.name$)!($(1),$(ii+1)) ogl:=$(ii); page.active = ii;
};
// Set symbol size // %C is the active dataset sec -p 1; set %C -z 20; // Set symbol shape sec -p 1; set %C -k 3; // Set symbol color sec -p 1; set %C -c color(blue); // Connect the symbols sec -p 1; set %C -l 1; // Change plot line color sec -p 1; set %C -cl color(red); // Set line width to 4 points sec -p 1; set %C -w 2000; // Change solid line to dash sec -p 1; set %C -d 1;
layer -s 2; // make layer 2 active Rescale; // rescale layer 2
legendupdate dest:=0 update:=0 mode:=custom custom:=@ln; // Modify the legend settings for each layers doc -e LW { // Set legend font size legend.fsize=28; // Set legend font color legend.color=color(blue); // Move legend to upper-left of the layer legend.x=layer.x.from+legend.dx/2; legend.y=layer.y.to-legend.dy/2; };
The thing is, I do not find the code that I can use to specify that I need all my graphs to be shown one underneath the other. Also,please check below my worksheet and what I am getting as graph. It should be one underneath eachother. Do you know how to extend the graph page more.