Howdy everyone. Apologies if this question is rudimentary--I've done a few searches and haven't found anything resembling the solution I'm after. Anyway...

I'm using Excel 2003. I have several names which are actually formulas. Ex:
Sheet1.xls!PercentA = SUM((C15+F15+I15)/(C18+F18+I18))
Sheet1.xls!PercentB = SUM((C16+F16+I16)/(C18+F18+I18))
Sheet1.xls!PercentC = SUM((C17+F17+I17)/(C18+F18+I18))
When I throw these into cells using "=PercentA" they're fine by themselves but I would like not to have them in cells at all.

I'd like the names to be part of a pie chart, but if I enter the series as:
=Sheet1.xls!PercentA,Sheet1.xls!PercentB,Sheet1.xls!PercentC
I get: "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."

Any help getting this squared away would be greatly appreciated.

Thank you!