Hello,

I'm new to VBA. I have tried the macro feature but it uses activechart which doesn't seem applicable here (I think).


In an open book with sheet1-3
data on sheet1
Create 33 tabs from sheet4, name them
add a line chart to each at A3 of size 5" by 3.5"
specify
chart title
x and y axis title
x axis labels
y axis 0.0 format numbers


10 named series no markers
legend at bottom


the data for some is in a block/range
for others it is non-adjacent cells
for others is static i.e. specific numbers 0.0

There are actually >100 but I will split into three workbooks.

Has anyone
1. any examples of something similar - or be so kind as to
2. code the first two or three and I'll do the rest.
3. if possible include a second chart on each tab - vertical bar chart.
4. tell me where I can get a list of the features changeable on each object
5. are there addins that do this?

Thanks hopefully in advance John

PS I know loops and arrays can be done to minimize code but I think they would be very diffiicult for a beginner to adapt.