T
TSW632
Hello,
In Excel 2003, I've been trying to use a dynamic named range for the
values in a pie chart:
=Cost Ctr Summary x Project!PieData12
But it won't accept that. Keeps telling 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."
Does anyone know why the values box on the series tab won't accept it?
In Excel 2003, I've been trying to use a dynamic named range for the
values in a pie chart:
=Cost Ctr Summary x Project!PieData12
But it won't accept that. Keeps telling 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."
Does anyone know why the values box on the series tab won't accept it?