Hi,
Here is some information on how to de-link chart and data.
http://peltiertech.com/Excel/ChartsH...ChartData.html
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rooky228" wrote in message
...
I would like to produce a chart and then rearrange the data to produce a
separate chart. Is there a way of separating a chart from it's data so
that
I can take the data and after rearrangement, produce another chart?