I would like to write a macro to plot a series of x & y values based on the row of the currently active cell. The first step is to click on a cell whose row you wish to plot. Then you run the macro...
Here's what I have so far :
Please Login or Register  to view this content.
My understanding is that, for example, RC17 means the current (active) row & column 17. Instead what I plot out are the data (x & Y) of row 1.
How can I be sure that the active cell is being accurately captured & that I will be plotting the data of the active row in the chart ?

Much thanks !

ak