PDA

View Full Version : chart automation



rusty
06-24-2009, 11:38 PM
attached is an example of what i need to automate. the first sheet shows the manipulation of the data and the charting.

the next 3 sheets are an example of the data download from the server (there are 150 of these).

thanks so much!!!!

rusty
06-24-2009, 11:39 PM
this is just to reiterate what i am trying to produce:


database chart automation
G'day,

I want to take a data download of 150 sheets and do a few calculations on each page to create the data series for 3 charts per sheet.

I then want the 3 charts to be exported in a particular format to a new excel file. I then want this process repeated for each sheet in the workbook. That is, 150 new excel files will be created, each with 3 charts per file.

I have taken courses, searched forums and even tried to call Bill Gates for help. Alas.

Please point me in the right direction!!!

Regards from Australia
Rusty