Automatic charting

[Hari]

Hi,

I do some simple VB using IF, for but havent been successful with charts.

I have a table of data based on which I create 3 charts.

Now I have 40 similar tables in same/other worksheets. Is it possible for
one to recreate through macro the same set of charts for those 40 other
tables of data using macro. My problem is that in chart the range
specification for data changes, so how will macro do that for new ranges of
data tables.

Please guide me.

Regards,
Hari
India

 

[Jon Peltier]

Hari -

VB/VBA works just fine for charting, as well as it works for other
Excel-related tasks. The object model takes a little investigation to
decipher, and there are a few tricks.

You can start by turning on the macro recorder while you make a few
charts. There are a few VBA keywords to help determine the range of
filled cells, things like <range>.CurrentRegion and
<range>.End(<xlDirection>). Check the help files for more info.

I have some suggestions for VBA charting on my web site:

http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html

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