ActiveChart.SeriesCollection(1).XValues = rng1.parent.Range(rng1, _
rng1.Offset(i,0)).Address(1,1,xlA1,True)

--
Regards,
Tom Ogilvy



"april27" wrote:

Hi! I am having trouble with constructing an x-axis in my macro for excel.
since the x-axis changes all the time I want to have a dynamic reference. The
code now is:

ActiveChart.SeriesCollection(1).XValues = rng1.Address rng1.Offset(i,
0).Address

As you can see the right hand side is incorrect. However I do not know how
to refer to the cells. Please help me out on this one!!!!