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

Short answer: Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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

Brilliant...thanks a lot!

"Tushar Mehta" wrote:

Short answer: Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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