Is there a way to create sparklines in a worksheet that contains multiple x and y columns? I have a worksheet with x1, x2 and x3 x-designations, but the sparkline command only creates sparklines for the last x-designation (x3 and subsequent y3 columns). x1 and x2 related columns are empty. Thanks! Stefan
// add sparklines to all cols from col 1 thru last col
sparklines sel:=0 c1:=1 c2:=$(wks.ncols);
// or
// add sparklines for all y cols up to end of sheet
// plot sparkline as y versus corresponding x
sparklines sel:=0 c1:=1 c2:=$(wks.ncols) xy:=1;
Hi Easwar, thanks for the reply. I just tried it, and it works. Funnily, this was exactly the command I was using before. Hmm, I upgraded to SR3 yesterday, maybe the sparkline behaviour was changed from SR2 to SR3? Anyway, it works now. Thanks! Stefan
Thanks Iris. Now I have a program which destroys all the graphs in the project. If I run that with the sparkline on in the files, the program fails and gives a error message saying its due to the sparklines that it cant execute. What needs to be added in that to get rid of this problem ? Thanks again,
x-function sparklines: mutliple xy cols
Posted - 09/03/2008 : 08:54:00 AM
