macro to create a chart from several worksheets

D

dpkk2

Hi,

I'm new to VBA. I want to write a macro to create a chart from several
worksheets in a workbook.
Eg. I have a workbook with four worksheets and each work sheet have
column A, B and C. Always column A represents X and B and C represent
Y. So my macro should draw 8 series in one chart.

Could someone help me please.

Many Thanks,

dpkk2
 
G

Guest

It sounds like this macro doesn't really have any
variation. I guess I would probably just record a macro
of yourself making said chart. That may actually be the
easiest.
 
J

Jon Peltier

Top