Hi everyone,
There is something wrong with my dynamic name range and I cannot figure

out what it is. Here is the workbook:
http://www.dciu.org/CSPD/generictemplate.xls

On the graph, I want the Spec Skills line to use the defined range:
Skills. When I put that in the series formula, it will tell me:
A formula in this worksheet contains one or more invalid references.
Verify that your formulas contain a valid path, workbook, range name,
and cell reference.


When I go to Define, Name and look at my formulas, I cannot see what is

making this not work. BTW, this worksheet may look simple, but I have
If then formulas in Column F39:F1000.


My goal for this worksheet is to have the dynamic chart reflect when a
session has been add (Column D) and use the Date Column (E) as the
value X. Thank you, cabybake