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:

ActiveChart.SeriesCollection(1).XValues = Range("A34,A34.End(xlDown)").Select
I tried to get the macro to get the code for me but it only selected the exact data range as seen below:

ActiveChart.Axes(xlCategory).Select
    ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$A$34:$A$40"
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,