This functionality is by design but you can easily change the source of any
chart. To do so, first click on the outside edge of the chart. Next,
right-click on your mouse and select "source data". Finally, in the source
data dialog box - data range tab - change the source reference via the "Data
range" input.

--
John Mansfield
http://www.cellmatrix.net


"Mr. Mike" wrote:

I have a spreadsheet and chart of which I need several instances. When I
copy and paste the sheet, the source data for the new chart is pointing to
the original spreadsheet. My goal is to have a new sheet and chart that is
independent from the original, however works the same way. New data entered
into the new spredsheet will display on the the new graph.