Perfect!!!

Thanks for the quick response!

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"billinr" wrote in message
...
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