I think the answer is to follow Jim Cone's suggestion, but also not change the Zoom settings. I wrote a suite of routines to do a similar thing (roll-in different sets of data into the same chart source, then copy/paste as metafile the chart), but I wrote into the routine to always set the source sheet zoom to 100 whenever run, so that even if the user changed the zoom, it wouldn't cause that problem.

BizMark