Hi,
I have 11 charts that are created automatically when data is copied into a worksheet,each chart also has a table to show the data. a few of the charts are dynamic . The problem I have is that the charts are re-sizing according to how much data they display. Once the 11 charts are generated I save them as a pdf but have to keep resizing the charts manually. i tried a few options such as keeping chart size and not resizing according to table contents but cannot keep the chart sizes the same.
Is there a way to keep the chart area the same size permanently regardless of what data it plots?
Many many thanks if you can help.
Bookmarks