I created 2 charts from two pivot tables in excel controlled by access using VBA. How do I copy a chart to a cell in a worksheet. Right now I just have two charts on sheet Chart1 and sheet Chart2. I don't know how to copy or locate a chart. Thanks. They probably will need to be sized too