I created 2 charts in Excel through VBA in Access, which controlled Excel. The charts are made from a sheet with two pivot tables in excel. I want to copy each chart onto a different worksheet and size them appropriately. How do I size charts and more importanly how do you copy and paste a chart or locate it to a specific cell in a worksheet. Currently, they are housed in sheet "chart1" and sheet 'chart2"
Much thanks!!!
Much thanks!!!