Trouble Using Named Ranges in a Chart

V

Vern

I am trying to use a named range as series data for a
chart. My named range has a OFFSET function set up so the
range dynamically adjusts when new data is added.

The trouble is when I enter the name into the "values" box
it get at "The formula you entered contains an error" box.

Is there a trick to entering Names?

Thanks
Vern
 
Top