Updating Data Series Range for existing chart

Topics: Project Management Forum, User Forum
May 5, 2015 at 2:43 PM
Edited May 5, 2015 at 2:51 PM
Hi.

I'm using PHP 5.4.12 with Excel 2007 and PHPExcel 1.8.0.

I've been able to successfully open up a prebuilt xlsx template file with monthly data values and several charts. Depending on the days in the month I am removing rows from the 31 day template file but the chart data series do not update with the deletion of the rows (as in Excel). Is there any way I can programmatically change the dataseries ranges for an existing chart with PHPExcel?

Thanks
May 11, 2015 at 1:36 PM
Anybody out there?