SeriesCollection.Values with variable Rows Error 1004

Hello,
i'm working with excel and especially with VBA since about two months. This forum and the solved problems were a great help getting into programming but now I have a problem myself i cant solve, using this board and other databases on the internet.

I'm programming a tool, which shall automatically create a Chart with all the data from coloumbs in the worksheet, to get an overview.

Please Login or Register  to view this content.

Edit: Maybe there is just a misspelling in the red part?
I hope you have an idea, it would be a great help!

what sort of range address is that?

assuming B contains the value 12.

'Power'!Z4S6:Z12S6

What do the S6's mean?