Filters hiding Chart

[Guest]

I have a chart positioned next to a data area; the data is used in the chart.
When I use the filters on the data, the rows that go away take the chart away.

Is there a setting to make the chart "float" above the worksheet, and not be
affected by the rows that are hidden by the filters?

I know I could move the chart.... but I would like to have it beside the data.


Thanks

 

[Peo Sjoblom]

You can copy the chart as picture (select the chart, hold down shift and
click edit and select copy as picture or use the camera tool), then position
the picture copy where you want it, then right click it and select format
picture, then click the properties tab and select don't move or size with
cells

 

[Guest]

Thanks for the suggestion. That solves the problem of the chart going away,
but now it no longer has the ability to reflect the filtered data. It becomes
static - I would still like to have the dynamic functionality.

Any other ideas?

Thanks

 

[Andy Pope]

Hi,

Just use Peo's suggestion about Don't move and Size on the actual chart
object.
Double click the chart area and use the setting on the Properties tab.

Cheers
Andy

 

[Guest]

Perfect!!!

Thanks for the quick response!

Hi,

Just use Peo's suggestion about Don't move and Size on the actual chart
object.
Double click the chart area and use the setting on the Properties tab.

Cheers
Andy