I have 1 named range created with the offset function on sheet(1):

Month=offset($A$1,0,0,counta($A:$A),1)

Simple to use as the x-as categories in a chart.

For the y-axis I want to use data which can be offset 1, 2, up to 20 columns.
Yes I can create 20 named ranges but to do that for 20 sheets in my workbook
gets cumbersome.
Therefor my question:
Can I use the offset function in the series values, like:
=offset(Month,0,7)

In VBA it it can be done with:
..SeriesCollection(2).Values = Month.Offset(0, 17)
But then I have to create one macro for each graph...again cumbersome.

Please help.

Thx.
Beertje.