Formula Error when creating Dynamic graph.....

Originally Posted by whylucky

I removed the lock on the file, and i also removed some of the extra names i was using when attempting to fix the error myself
If you would be kind enough to look it over again

For each name reference (exp1 and temp1), copy the referenced formula and paste it in some cell temporarily to allow you to debug it.

They return a #REF error because the last parameter evaluates to zero. OFFSET(...,0,0) is not a valid reference.

Aside.... Using OFFSET in a named reference is bad enough, performance-wise. All such references are evaluated every time Excel (re)calculates anything in the workbook.

To make matters worse, you use COUNTA(B:B) and COUNTA(C:C). That causes Excel to examine all 65536 rows (xls file) of those columns every time Excel (re)calculates anything in the workbook. If you ever "upgrade" the file to xlsx, that will 1,048,576 rows. Ouch!

You should consider using INDEX:INDEX instead of OFFSET. And if you must use COUNTA, use a limited range references, something that is more reasonable (but appropriate for your purposes, a judgment call). For example, COUNTA($C$1:$C$1000).