Free Support Forum -

Chart doesn't update when deleting columns

When a column is deleted from a worksheet if there is a chart it should update the data range, the values stored in NSeries, to reflect this change.

For example if you had a chart looking at the data in cells M4 through M10 and you delete column F, then the chart should now be looking at columns L4 through L10.

I assume this is also true of inserting a column, deleting a row, and inserting a row although I haven’t tested any of these.


Thanks for your posting and interest in Aspose.Cells for .NET.

Kindly test your issue with the latest version: Aspose.Cells
for .NET v6.0.1.2

If the problem does not go away, then please provide us your sample C# project replicating the problem and the source (template) xls/xlsx files if any. We will investigate the problem and help you asap.