charting series that are into different files (prompting each time)

U

uriel78

I hope I can explain what I mean....

I've got several files, each one of them contains 4 sheets called with the
same name (alfa, beta, gamma, delta)
In each sheet, in columns I:I and L:L, there are X and Y values for a
scatter plot

I wish I could create, in a new workbook, a chart that contains I:I L:L
series from different files.
So I want to do a macro that prompt me for browsing and choosing a file and
then chart the series that is in sheet "alfa" columns I , L. Then prompt me
for choosing another file and do the same thing as before said...

Someone can help me...?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using =Offset in Charts 1
programming 33 tabs with 1 chart on each, 9 series lines per chart 1
Chart error: plotting series data XY scatter plot 3
sorry...I'm a terrible idiot and still can't do anything...:-((( 6
XY scatter plot with more than 32000 rows in Excel 2003 0
Charts with Time as X-Axis 6
Using Variable array in Excel VBA charting 7
Extend values of a chart series 10

Top