How can I Freeze a graph?

[Mark J]

I need to make a series fo graphs from the same data. I sort the data,
make a graph, and sort the data again, and make a new graph. Well each
time I do the sort, the first graph updates.

I want to get the graph perfect, and "save" the graph so it will not
change (freeze). Then I can go on and sort and make a new one.

I think what I want is a "paste special" values only for a graph.

I can place these in a separate workbook and not update every time I
open, but this is not a very satisfactory solution.

mark

 

[Bernard V Liengme]

Hi Mark,
A couple of option:
1) Click on a data series in the chart. The Formula Bar has something like
=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$5,Sheet1!$B$2:$B$5,1). With the mouse
pointer in the Formula Bar press F9 to calculate; the Formula Bar now reads
something like =SERIES("y",{1,2,3,4},{2,4,6,8},1). Repeat for each data
series.
2) Click to select the chart; hold down SHIFT and use menu item Edit|Copy
Picture (As Shown on Screen), click OK; now use Paste. You have made a
picture of the chart.
best wishes
Bernard

 

[Jon Peltier]

Mark -

I have a couple additional suggestions on my web site:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

- Jon