Filter excel data without hiding a Graph

[volabos]

Hi,

In the attached Excelbook, I have tabular data which I intend to filter based on some criteria, let say where a = 1

However when I apply filter, the adjacent graph also gets hidden. Is it possible to filter my data without distorting the complete view of the Chart?

Appreciate any pointer on that :banghead:

[werafa]

One option is to manipulate chartobject properties.
you can set chart dimensions and the location of the top left corner after each change

Werafa