Graphs and VBA
 

Hello,

I currently have the following:

I have a spreadsheet with a bunch of data and when i double click in a cell
that has information that people want to analyze, a graph opens up that gives
more information. This is working fine accept now a person wants to go look
at another number and double clicks on that number and another tab is created
with another graph. Now the person wants to go to the first graph but the
information in the first graph disappeared because the source info for the
graphs has changed. Is there a way to store information within the graph so
that it doesnt need the original information so that a person can have
multiple graphs open at the same time?

Hope this is somewhat clear.

Alex