Hi All!

I have over 30 box and whisker charts set up for a particular sample source. there are 20 other sample sources all with data in the exact same format. Is there a way i can bulk change the sources of the charts so i can simply copy them into a new page and change the page the charts are targeting for their information?

Should point out at this point that i am very comfortable with Excel and VBA if needed.

Thanks very much in advance