Cells.InsertRow() Method Won't Update Charts


If you have a chart that specifies (for example) $B$1:$B$3 as the data range, you can insert a row above B3 and the chart will update itself.

When I use the InsertRow() method, the Charts in Excel are not updated to reflect the changes. Is this a bug or is there something else I need to do?

Thanks, Natan.


Hi Natan,

We just didn’t think of that. Please try this attached dll. It should solve this issue.