Dynamically update chart

Topics: Developer Forum, Project Management Forum, User Forum
Nov 7, 2012 at 12:02 PM

I have two sheets in a excel file. The first sheet has the data for the chart. And the second one has the chart based on the sheet1 data. when I open and edit the values using PHPExcel, the sheet2 (i.e the sheet which has the chart) is deleted. instead of chart if I add data in sheet2, sheet3 .. all are there.  Please help me someone.