Changing source in Excel 2003 (excel 2003)

Topic

New Reply

I have 32 worksheets with 5 charts on each one. All the same kinds of charts. I have 32 source sheets called S1 to S32. The charts are D1 to D32. How can i write a macro to iterate through D2 to D32 and change the sources to the matching data sheet – D1, D2 etc. D1 is the source to the charts on S1. D2 is the source for the charts on S2 and so on. Thank you for the help.

Reply | Quote

Replies

I’m confused by your description:
First you state that S1 etc. are the source sheets and D1 etc. the chart sheets.
Then you ask to make D1 the source for the charts on S1 – exactly the reverse.

Reply | Quote

oh, sorry. D1 is the source to S1. I’m trying to change the references for all the S1 charts (worksheets S1 to S32) from D1 to D2, D2, D4 etc.

Reply | Quote

I still don’t understand your description, sorry.

Reply | Quote

Can you record code of you changing one of the sources?

Reply | Quote