Copy cart to a new sheet...

[Eva_]

Is it possible to copy a chart to a new sheet, using the data from new sheet?

[Andy Pope]

No.

If you copy the chart it will reference the original data source.

You need to either copy the chart and then update the references or
Copy the whole sheet and then update the data.

[Eva_]

So in other words, no easy way... :-)

Anyway, thanks for your help and quick reply...