Hi,
You embedded the graph into a cell of a resulting report sheet. When data is re-imported, this worksheet is updated with new result and the graph in the cell is wiped out. So you can embed graph as a worksheet within the same workbook. To do that, just right click on the name tab of any worksheet and select Add Graph as Sheet. This graph will not be wiped out after recalculation.
Thanks, James |