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

"Peo Sjoblom" wrote:

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


--
Regards,

Peo Sjoblom



"billinr" wrote in message
...
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