david_t
03-30-2010, 01:33 PM
Hi everyone,
I am trying to design a macro that will extend the series range of the data used in a line chart by one column.
Basically, I have multiple workbooks open, each with multiple sheets, with each sheet containing multiple graphs, with each chart containing multiple series. I really need a macro that will loop through every graph (there's about 200 of the things) extending the data series by one column when I receive a new months data (the x-axis does not need to change). The data is stored in qute an illogical format in tables scattered around another workbook so the macro really just needs to add one to the columns being considered (the data ponts are stored from left to right in one row per series)
I'm quite new to VBA but I think I have managed to piece together the looping through workbooks, then sheets, then charts part but come unstuck on the charts themselves.
And any macro must work in Excel 2003!
Any help will be really apreciated!
Thanks
Dave
I am trying to design a macro that will extend the series range of the data used in a line chart by one column.
Basically, I have multiple workbooks open, each with multiple sheets, with each sheet containing multiple graphs, with each chart containing multiple series. I really need a macro that will loop through every graph (there's about 200 of the things) extending the data series by one column when I receive a new months data (the x-axis does not need to change). The data is stored in qute an illogical format in tables scattered around another workbook so the macro really just needs to add one to the columns being considered (the data ponts are stored from left to right in one row per series)
I'm quite new to VBA but I think I have managed to piece together the looping through workbooks, then sheets, then charts part but come unstuck on the charts themselves.
And any macro must work in Excel 2003!
Any help will be really apreciated!
Thanks
Dave