I've searched for the answer for this everywhere, but I have 3 named ranges that I chart dynamically. The ranges work fine, when I click on the names themselves it highlights the correct cells. However, excel will not allow me to chart with these ranges. I get the "a formula in this worksheet contains one or more invalid references" error. I enter the series values as follows: = Sheet1!Name. The names themselves are all properly referenced ie $A$1, $B$1 etc. I'm out of ideas why this isn't working. Thanks for any help.