Hi Rajan, I would be doing filter not on the pivot table...but on the data in the sheet 1 which should reflect in the chart and the table.
Cheers Atul On 7/7/11, Rajan_Verma <rajanverma1...@gmail.com> wrote: > Hi, > It's a pivot chart in your sheets its taking references from Pivot Table , > when you will apply filter in Pivot table it will Show Only Filter Summary > Data, > > -----Original Message----- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Atul Kesaria > Sent: Thursday, July 07, 2011 1:18 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Help on Chart > > Hello Team, > > I think i was not very clear on my request. Please find attached excel sheet > in which there is main data on sheet 1 and on the basis of which I have > prepare chart on sheet 6. What I want is as soon as set a filter on Sheet 1 > the chart on sheet 6 should be refreshed. > > Cheers > Atul > > On 7/7/11, Rajan_Verma <rajanverma1...@gmail.com> wrote: >> >> See if it help >> >> >> -----Original Message----- >> From: excel-macros@googlegroups.com >> [mailto:excel-macros@googlegroups.com] >> On Behalf Of Atul Kesaria >> Sent: Thursday, July 07, 2011 12:11 PM >> To: excel-macros >> Cc: atul.kesaria >> Subject: $$Excel-Macros$$ Help on Chart >> >> Hello Team, >> >> I am preparing chart basis certain data. However wanted to check some >> way to prepare the chart only on the data which reflect in the excel >> sheet post i do a filter. So as soon as I change the filter the chart >> should change. >> >> Do let me know if that can be done. >> >> Cheers >> Atul >> >> -- >> ---------------------------------------------------------------------- >> ------ >> ------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >> and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> ---------------------------------------------------------------------- >> ------------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips >> and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and > Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel