| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
charting series that are into different files (prompting each time)
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...? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Series of backed up files with time and date | Excel Discussion (Misc queries) | |||
| charting time series with milliseconds with scatter | Charts and Charting in Excel | |||
| Charting Time Series Data | Charts and Charting in Excel | |||
| Time-Series Charting | Charts and Charting in Excel | |||
| Alternatives for Excel for charting dated time-series? | Charts and Charting in Excel | |||
Linear Mode
