LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default EXCEL FILTERS AND CHARTS

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table filters, especially DATE filters chris Excel Worksheet Functions 0 August 27th 08 04:33 AM
Bug? Chart filters are changing other charts blcomp Charts and Charting in Excel 0 April 1st 08 11:16 PM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
Using Pivot Charts, how to hide field values in second level filters? elrao Excel Discussion (Misc queries) 1 June 17th 05 10:22 AM
Pivot Charts, hiding field values in second level filters? elrao Charts and Charting in Excel 1 June 17th 05 10:19 AM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"