Hi All,
I hope someone can help as I just cant figure this out.
I wanted to learn howto plot a series of latitude/longtitudes points to a background map on a chart using the Excel scatter plot. Being a novice I thought I'd make a start by just drawing 4 points of a square and try to move these points around using dynamic ranges.
On the attached spreadsheet I use cell A1 to increment in 2's and this changes the range that the chart gets it's data (B3-C6) from.
When A1 = 0 it draws the square
when A1 = 2 it moves the square
When A1 = 4 it moves the square again but the top left corner is drawn at (0.5,1) to prove it can
But when A1 = 6 or 8 it doesn't plot the points in the correct places and I cant understand why.
It seems everytime I use less then 4 points to plot it screws up the plotting? I was only messing with this to get a better understanding of scatter plots and because eventually I hope to have like 2000+ points to plot marking geographical locations on a backdrop map and animate this over a series of frames. But it seems like my experimenting just opened up a can of worms that I cant get past.
I guess my question is why doesn't it plot less than 4 points accurately and if that's just something silly I missed or did wrong (FINGERS CROSSED). Can someone suggest a method that will allow me to vary the number of rows dynamically.
Eg eventually somedays there will be like 1000 points to plot and other times more or less.
I'm guessing my formula wont do the trick
=IF(OFFSET(B3,0,2+$A$1,1,1)="","",OFFSET(B3,0,2+$A$1,1,1))
Would appreciate any help as I've been pulling my hair out here....
Bookmarks