Hello,

I am trying to make a function that will trend data if prompted. I am able to graph the data but when I try to select the value for the x axis it doesn't work. I know there is something wrong with the code but can't fix it:

Please Login or Register  to view this content.
I tried to get the macro to get the code for me but it only selected the exact data range as seen below:

Please Login or Register  to view this content.
however, since data is continually added the bottom of the graph will change (from A40 now to perhaps A50 the next time)

what do I have to change.

thanks,