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