Prev: Insert Formula based in cell user clicks
Next: hours / minutes
From: John L on 27 Apr 2010 15:54
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
From: Don Guillett on 27 Apr 2010 17:18
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
dguillett(a)gmail.com
"John L" <JohnL(a)discussions.microsoft.com> wrote in message
news:4217F4F2-238E-41FB-8CEB-CC90F9AEEBA5(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Insert Formula based in cell user clicks
Next: hours / minutes