How can I Freeze a graph?

M

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
 
B

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
 
Top