EXCEL FILTERS AND CHARTS

[Lauren]

Hello.

I've made a workbook whereby I have a table of data on one worksheet from
which I've made charts that I've placed on another worksheet. When I apply
autofilter on the data, it also filters the charts. However is it possible to
move a filter to the same worksheet as the charts so that one doesn't have to
flick back and forth between the worksheets to apply the filter?
I've tried copying and pasting the table to the same worksheet, but that
doesn't work. I've tried using the cell references but that doesn't work
either. Is this even possible?
Any help would be greatly appreciated.
Thanks in advance,

Lauren

 

[Pete_UK]

Have you tried moving the chart, so that it is in the same sheet as
the data?

Hope this helps.

Pete

 

[Lauren]

If possible I want to keep the charts and the data on seperate sheets.
But thank you anyway.

Lauren