Hi all, I have a table on Excel like below table, and I want to write a macro to draw charts and graphs in power point..... I don't know how to write such a macro.... One of the graphs is depend on Dname per week, For instance, it draws chart from Feb.09.09 to Feb.15.09 we have 15 Jack, 10 Alice, and 20 Dave and draw bellow chart in power point…
Name T.Nomber DName DQuantity Date A 001 Jack 6 Feb. 09.09 B 002 Alice 10 Feb. 13.09 C 004 Jack 9 Feb. 10.09 D 002,001 Dave 20 Feb. 12.09 Thanks all, --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---