Pasting A Chart As Values Within A Worksheet

[reportingallday]

Hi,

Can anyone let me know how you paste a chart as values or how you can get it to keep its data the same even when you change the data source/source data? Thanks

[Andy Pope]

Jon's page has some suggestions for de linking chart data
http://peltiertech.com/Excel/ChartsH...ChartData.html