Hi
I have three spread sheets with identically laid out data. The data itself is different in each spreadsheet.
I have made charts for the first sheet. I wonder if I could copy and paste them into the second and third sheets and somehow alter the data selection en masse, to quickly update the charts for the other data sets.
Does this make sense?
Hoping some clever person can help me.
I'm using Excel 2010 btw.
With thanks in advance...