This program was written in order to allow Excel to easily find the co-ordinates of any point on an XY (Scatter) graph. Currently Excel will show the co-ordinates of a data point on a series, but if there is no data point at the location you want to find, it is not so easy. With this add-in loaded all you have to do is:
1. Press the Find CoOrds button
2. Move the horizontal and vertical dotted lines that will appear on the graph into position so that their intersection is the point you want to find. While you are doing this the co-ordinates will be displayed on a toolbar button .
3. Once you have them both correctly positioned, press the co-ordinate display button and the lines will be removed and a point and co-ordinate label added to the graph.
The number formatting will be that of the relevant axes, so if there are too many decimal places, try changing the number format of the axis.
Download ChartCoOrds.xla (zipped)
|Please email me if you wish to comment on this program, or to send in any bug reports or suggestions.|