dynamic chart with 2 label X-axis

[juzzi]

hello everybody, my problem is the following: i would create a dynamic chart that shows the last (let's say) 21 values and i manage to do this throught the definition of names, but i would like to represent also a double label for the x-axis, that is year (column A) and trimester (column B)..how could I do?
the name I created is the following:
=OFFSET('Valori assoluti'!$A$1:$B$1;COUNTA('Valori assoluti'!$C:$C)-'Valori assoluti'!$K$1;0;'Valori assoluti'!$K$1;1)

 

[Andrew Poulsom]

You shouldn't need to do that. OFFSET's last argument determines the width. The number of columns in the first argument is irrelevant. At least that's the case if you assign the formula to a defined name, which is what Pedro and I did.