Creating Dynamic Chart (via dynamic named range)

[PatrickO]

Hello,

I am working in Excel 2003

I am attempting to create a dynamic chart by utilizing dynamic named ranges. For my dynamic named range, for example, I have =OFFSET('Chart'!$E$2,0,0,COUNTA(A2:A40)-COUNTIF(A2:A40,""))

I am able to verify the dynamic name range is working by using the sum() function, but I am unable to use the dynamic named range in the Series() function to create my dynamic chart.

I get an error message saying that the formula contains errors. If I manually try to put the offset formula as seen above, I get an error message that says the function is not valid.

Thanks in advance for your help.

 

[PatrickO]

I may have answered my question... partially.

It seems the issue was that I was directly putting the named range into the series data, but what I really needed to do was list it like this:

'Chart'!Named_Range

Where this doesn't work is the category axis labels. I am still unable to dynamically change the category axis labels, either through a named range, or through offset function.

*EDIT*

Ok, it seems that I can just set the category axis label to the maximum possible, and the chart will only display if the data is available.