I'm using a simple macro to draw bubble charts using just
6 cells of data. The macro also uses a single cell of
text as the title of the chart and the name of the new
sheet the chart becomes. I then paste the sheets into a
different file (by hand). When I return to the original
file to do the next chart, when I change the data in the 6
cells and draw the new chart, it changes the position of
the bubbles in all the old charts. Charts retain,
however, their title and sheet name.