Dynamic Chart Issue

Hi,

I'm trying to create a dynamic 100% Stacked Column chart but every time I try to add the series it says "The formula you typed contains an error.".

When I select the named range in Name Manager, it highlights the correct range but it won't seem to let me add it to a chart as a Series.

The formula is:

=OFFSET('Main Sheet'!$AS$44,1,0,(MATCH(9.99E+307,'Main Sheet'!$AS$45:$AS$61)),1)

I've tried transposing the table and referencing the row rather than the column but to no avail.

I also changed the height to 12 to see if that would work but it didn't.

Can someone shed some light on where I'm going wrong?

Thanks,
M