Everything works fine with my chart if I keep the pivot table closed/collapsed. I've successfully created a regular chart based off the data in a pivot table (which summarizes information in a backend table). I'm on Excel:Mac 2011 which still has no pivot charts (as far as I've heard).
