Damon,
Thanks for the reply. I have manually created a sample grid in Excel as a X-Y Scatter Chart to show all. However, being new to message boards, not sure how to import for display. Where are the drawing object tools you mention within the browser or this website. The cut and paste tool within my browser didn't seem to work. How do you attach files or bring into this reply message box?
Hopefully, my rephrasing the question will preclude me from having to generate a graphic:
I would like Excel to automatically generate data points (receptors), X and Y coordinates in Columns A and B starting from say 0,0 to 10000, 10000 in steps (increment) of 100 meters. I realize that this will create quite a number of rows, but I believe Excel X-Y Scatter charts must have data in two columns.
0 0
0 100
0 200
0 300
.. ..
0 2000
100 0
100 100
100 200
100 300
.. ..
100 2000 . . .
200 100
200 200
200 300
.. ..
200 2000. . .
.. ..
2000 0
2000 100
2000 200
2000 300
.. ..
2000 2000
Any help would be appreciated.