Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.office.developer.vba,microsoft.public.excel.charting,microsoft.public.excel.worksheet.functions
|
|
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...
|