Hi,
I'm having issues with developing a macro that will copy a chart from one sheet, on which there is data that the chart is plotting, to another where there is new data (same format as the first sheet. I want the macro to then change the title and the series info to that of the name of the sheet.
I've had limited success thus far as i've encountered problems with the numbering system of the charts.
Has anyone tackled this before or got any pointers?
Thanks,
James.
I'm having issues with developing a macro that will copy a chart from one sheet, on which there is data that the chart is plotting, to another where there is new data (same format as the first sheet. I want the macro to then change the title and the series info to that of the name of the sheet.
I've had limited success thus far as i've encountered problems with the numbering system of the charts.
Has anyone tackled this before or got any pointers?
Thanks,
James.