I'm trying to have a pie chart that is populated by two separate numbers. The numbers are coming from a separate sheet. The pie chart works if I enter numbers in manually but when I try to have those numbers come from a separate sheet I get the #value error saying its the wrong data type.

the basic process is as follows,

User enters his numbers on a spreadsheet.
Those numbers are automatically populated onto a seperate sheet in a different workbook in specified cells.
The pie chart uses those numbers in the cells indicated to populate its chart.
Fin


Thanks for the help