Also, if the charts are in fact NOT working and can't be fixed easily (or soon) I want to submit an idea for a workaround.
Because PHPExcel currently destroys charts (for me at least) when adding data to a template. A simple workaround is to use PHPExcel to output raw data to an .xslx or even .csv file. After this, the original template file uses VBA to automatically
(or prompt the user to) import the raw data into the template.
Just figured I would pass this on for anyone who might be struggling with a similar problem. Even if it might be common sense for most.