View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
TSW632[_2_] TSW632[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel 2003 dynamic named range for the values in a pie chart

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?