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!!!!