macro to create a chart from several worksheets
 

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

macro to create a chart from several worksheets
 

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.
-----Original Message-----
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
.

macro to create a chart from several worksheets
 

Here are a couple web pages that might help:

http://peltiertech.com/Excel/ChartsH...kChartVBA.html
http://peltiertech.com/Excel/ChartsH...iffSheets.html

In a macro, getting data from different sheets is no problem. Just use
the seriescollection.newseries approach, and define your X and Y ranges
accordingly.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

dpkk2 wrote:

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