View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mizterbusy mizterbusy is offline
external usenet poster
 
Posts: 4
Default How do you isolate a graph from it's data?

Hi everyone,

I have a very large file with lots of data and one sheet full of
graphs.

I need to distribute the graphs but not the data and what I've been
doing is right-clicking the sheet with graphs and selecting

move or copy THEN
create new book THEN
new book

to create a book with the one sheet of graphs. I've then emailed this
sheet out.

My problem now is that when I try this technique, my graphs all get
distorted for some reason.

Can anyone advise me what the best way to do this is - ie. how do you
best quarantine graphs from their data simply and easily, without
distorting the graphs?

Any help would be much appreciated.

Thanks all.