View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jeftiong jeftiong is offline
external usenet poster
 
Posts: 5
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...