Update 2nd Chart

[John Calder]

Hi

I run Win2k with Excel 2K

When I copy a chart to another sheet I would like it to update at the same
time as I update the original chart.

At present I copy the chart and paste it to another sheet but when I update
the original chart the copied one stays the same.

Can anyone tell me how to do this?


Thanks

John

 

[MarkM]

Rather than copy the chart to the different sheet, why don't you create the
chart on the new sheet looking at the same data range.