stop chart series from updating
 

I have created a chart and now want to change the data it uses as the source,
BUT I do not want my original chart to update as I want to create a
different chart. Does anyone know to freeze the chart so it is no longer
linked to the cells?

One way would be to take a picture of the chart as it is now.
Click the chart; hold Shift key down; use menu item Edit and select Copy
Picture; use As displayed; then use Paste command to paste picture on
worksheet or in a Word Doc, etc.

Another way is to delink the chart.
Click of a data series in the chart, look in Formula Bar and you see
something like =SERIES(Sheet1!$E$13,Sheet1!$D$14:$D$19,Sheet1!$E$ 14:$E$19,1)
Click anywhere in the Formula Bar and press F9
Formula bar has something like =SERIES("y",{1,2,3,4,5,6},{7,8,9,6,7,8},1)
Note the cell references are replaced by values.

Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"johnmoreland21" wrote in message
...
I have created a chart and now want to change the data it uses as the
source,
BUT I do not want my original chart to update as I want to create a
different chart. Does anyone know to freeze the chart so it is no longer
linked to the cells?