Is there a way in which a chart can be automatically made to modify its data
range? I have a spreadsheet into which we have a lot of charts. On a regular
basis, we add extra data ( cut and paste from another spreadsheet), and then
have to spend a long period of time modifying the ranges of each of the
charts in order to account for the new data. Is there a way in which a chart
setup is such that it looks at a whole column, rather than a specific array
of cell???

Please help

Phil