View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.office.developer.vba,microsoft.public.excel.charting,microsoft.public.excel.worksheet.functions
[email protected] Jeffrey.Tiong@gmail.com is offline
external usenet poster
 
Posts: 4
Default plot graph from multiple worksheet as embedded chart object on every worksheet

Hi i want to plot the graph for every worksheet (column B and column
D). I have more than 50 worksheets in the same workbook. How do i write
a macro to ask the excel to plot the graph for every sheet and present
the chart object on the same sheet? thank you very much for your help!
i have been working on this over 2 days still cannot figure it out...