macro to create a chart from several worksheets

[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

 

[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.

 

[Jon Peltier]

Here are a couple web pages that might help:

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html
http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.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/
_______