I have data to be plotted that looks like this, but for the whole year:
I calculate the dates such as 1-Feb-11 and 28-Feb-11 and I would like to plot the four points within that date range.
Using the MATCH function I can calculate 6 and 9 as the row numbers, and then with the ADDRESS function I can calculate $B$6 and $B$9 as the endpoints of the data.
How can I specify Sheet1!$B$6:$B$9 as the range of Y-value data to plot? I can do it manually with Select Data, but I need to do it dynamically, I suppose using VBA. Of course I would use Sheet!$A$6:$A$9 for the X-values.
Thanks for your help,