chart only represent the data of visible cells if you hide any rows or will apply filter it will show the data of visible cells only
check the attachment choose any name u will see the chart will automatically change if it is not working as per the default setting . http://office.microsoft.com/en-us/excel-help/display-hidden-worksheet-data-in-a-chart-HP005202880.aspx On Thu, Jul 7, 2011 at 12:11 PM, Atul Kesaria <atul.kesa...@gmail.com>wrote: > 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 > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> http://akoul.posterous.com/ *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
