I have a table filtered like below. And I add the chart beside by C# with microsoft.office.interop.excel.

But when I cancel the filter,the chart may be distorted.

How to solve it then?

CodePudding user response：

You need to change this setting on your chart ...

... you can do this programmatically using this property on your ChartObject instance ...

chartObject.Placement = XlPlacement.xlFreeFloating;

These are the other options so it fits the bill. I tested it and it works ...