stop chart series from updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Back
Top