Dynamic Ranges in Excel 2007 Charts

[sturcol]

Hi,

I am trying to use dynamic ranges in an Excel 2007 chart. I can define the ranges in the worksheet - i.e.:
By_Plant - =OFFSET(Analysis!$A$2,0,0,COUNTA(Analysis!$A:$A)-1,)

This works fine, but I can't seem to incorporate either the range name or the offset formula in my chart. If I use the formula, I get the error message 'That function is not valid', if I use the range name, I ge tthe message 'The formula you typed contains an error'

Can anyone help. I used to use this functionality often in Excel (2003) and never had any problems with it, but I have never been able to get it to work in 2007.

Regards to all.

Colin

 

[AhoyNC]

See if attached link is of any help.

https://www.youtube.com/watch?v=7le-m8YRP6M

 

[sturcol]

See if attached link is of any help.

https://www.youtube.com/watch?v=7le-m8YRP6M

Thanks for that. In the end, I got it to work - here is what I entered in the chart range:

='Engineering Milestones Dashboard 1.xlsm'!PCTotal_Achieved

'PCTotal_Achieved' being the dynamic range. I don't know why this has been such a problem as I know it used to work on Excel 2003. At least I know it works now.

Regards.

Colin