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

[John L]

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

 

[Don Guillett]

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