hi
i have a problem and no more ideas to solve it

i have a 3d diagramm: sensor-valus on the z axis, sensor on the y axis
and on the x axis should be the time read out of my excel sheet.
but there´s the problem, every time i try to put the x axis valus via
VBA i get a runTime error 1004 (cant set Range method of Series
collection objekt).
i tryed it with the macro recorder and geot the same error.

code that sould work but don´t work

Charts("BergeS16").SeriesCollection(1).XValues = "=Sheet4!S1Z1:S41Z1"

Are there any other posibilities to change the x axis valus, or any
ideas were my fault could be?

tx! CU!
Patrick