Is there a way to create a list of x,y points (say columns A and B) from a mouse click, but something that is on a grid (like a scatter plot). Basically, some way of showing a grid and then clicking points on it to make the x,y data.
Not that it needs to be done at this point, but ideally:
- a circle could show after the click
- a picture could be placed over top and then clicks could be performed over top of it (basically like sort of trace it with dots)
- snap to grid within a certain tolerance
Basically just looking for an overall idea, how to get started, and if this could even be done in Excel. Maybe I need something more like VB instead?