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
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