Assuming from your description that you have multiple charts on the same
worksheet, using similarly arranged data.

1. Put some typical data in the appropriate layout and make your chart
on a new workbook. Save this workbook. This is your chart template workbook.

2. Select the range containing the data and underlying the chart on the
chart templateworkbook, and use Cut (not copy) to place it on the clipboard.

3. Select a cell on the target worksheet, and paste.

4. Close the chart template workbook without saving.

5. Reopen the chart template workbook, and the chart and data you cut
will have been restored.

6. Repeat steps 2 through five as needed.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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.