selecting chart

[thedreamshaper]

I am somewhat experienced with VBA but rather new to making it work with charts, so now i have a code which i basickly want to copy a chart spreadsheet and insert a new one with same format, problem is my code stops and tells me i cant

Please Login or Register  to view this content.

the problem is: The item with the specified name wasnt found

and the debugger says the problem is

Please Login or Register  to view this content.

So how do i work around this ?

Thanks guys

[Andy Pope]

Rather than using a name you could use a numeric index.

Please Login or Register  to view this content.

If there are more than 1 chart object then this will get the latest one.

Please Login or Register  to view this content.

[thedreamshaper]

I cant quite get it working for me, i tried the following:

Please Login or Register  to view this content.

[Andy Pope]

does it report the same error?

can you post example workbook

[thedreamshaper]

I have attached the file, basically i need to create graphs like the one in the workbook for all sets of PF and BM in the workbooks list.

Thx

[Andy Pope]

this will go through the lines 2 at a time.

Please Login or Register  to view this content.

But looking at your data you will need to alter the code to handle multiple series.