automatic graph creation

Hello Junne,

You can create graphs/charts this way. However, you forgot to mention what type of chart you will be using. I am assuming your numbers in column "A" are European decimal values. Let me know what you want to use, and I will help you with the code.

Sincerely,
Leith Ross

Hi,

I would like to create a xy (scatter) graph.
I've included a txt file like the ones I will use with this macro.
I think creating the graph isn't realy the problem since I can record a macro while creating one and then copy the code,
but things like adding the name of the file (zone1.xyz) to a variable, so I can use it to name the new sheet this way. And placing the new sheet at the end of the existing sheets.
And then if it is possible I would like to bring up a dropdown list with in it the names of the existing sheets so I can select the destination sheet for the graph.

Thanx very much for your help,
Jurgen