programming 33 tabs with 1 chart on each, 9 series lines per chart
 

Hello,
I'm a VBA beginner and I've tried the macro recording but it uses the
activesheet. The examples I've found use named and/or contiguous ranges.
They are not specific enough or too complicated, using arrays. Even though
there is more code by explicitly programming, it is very clear.

In an open workbook, Beginning at Sheet4 I need to add

33 tabs,
name each tab
create a line chart, no markers, on each tab
insert 9 series with different colours,
preferably specify dashes/dots, thickness etc.
specify the data range for series each as six not contiguous cells
chart title
y axis title
x axis labels
specify chart size - to fit on one landscape page

Could someone please program the first two tabs and charts and I'll copy and
fill in the rest or direct me to somewhere that does something comparable.

Thanks in advance,
John

programming 33 tabs with 1 chart on each, 9 series lines per chart
 

I wonder if you could use one chart that is populated by a double click on
the title row of the column of data?
Only if requested, OFF list to my address below, I'll be happy to send a
stock market file of mine illustrating this idea. And/or send me your file
to look at
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John L" wrote in message
...
Hello,
I'm a VBA beginner and I've tried the macro recording but it uses the
activesheet. The examples I've found use named and/or contiguous ranges.
They are not specific enough or too complicated, using arrays. Even
though
there is more code by explicitly programming, it is very clear.

In an open workbook, Beginning at Sheet4 I need to add

33 tabs,
name each tab
create a line chart, no markers, on each tab
insert 9 series with different colours,
preferably specify dashes/dots, thickness etc.
specify the data range for series each as six not contiguous cells
chart title
y axis title
x axis labels
specify chart size - to fit on one landscape page

Could someone please program the first two tabs and charts and I'll copy
and
fill in the rest or direct me to somewhere that does something comparable.

Thanks in advance,
John