Hello Chandru, See the attached. If doesn't have 12 entries it will adjust to available entries. If do have more than 12 week entries will show the last 12 week data.
HTH Haseeb For tips visit; http://www.excelfox.com/forum/ -- ---------------------------------------------------------------------------------- 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
Dynamic_Chart.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
