Dynamic Chart Issue

[MP1286]

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:

Please Login or Register  to view this content.

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

[MrShorty]

The name definition looks right to me. How are you putting the named range into the SERIES() definition?

[MP1286]

The name definition looks right to me. How are you putting the named range into the SERIES() definition?

You jogged my memory and made me realise I was inputting the named range without specifying the sheet first. All fixed now, thanks!