Expanding charts to update new data
Posted by David Chung on October 17, 2001 8:40 PM
Dear Mr Excel,
This is a variation of an earlier question on this topic. I have four charts per sheet, there are four sheets, each sheet represents a state. I store the data on the fifth sheet. The data is organised into blocks eg: For Product line A: Turnover (NSW,VIC,QLD,SA), Gross Margin (NSW,...); For Product line B: Turnover....etc.
Each month I update the data and all the 16 charts, a tedious, time consuming task as I cannot simply select the data and drop on each chart to update. What is the best way to update all these charts?