Plot Area Changes in Charts
Hi. I have a spreadsheet that has several hundred embedded charts. The data
is updated monthly and the charts automatically update themselves. The problem is that when the data is updated on the charts, the plot area reverts to some default size which does not take advantage of alot of the chart size. I don't want to go to each chart every month and manually increase the plot area. Any ideas? Thanks. Jeff G |
Plot Area Changes in Charts
I forgot to mention that the files are excel 2003.
"Jeff Gross" wrote: Hi. I have a spreadsheet that has several hundred embedded charts. The data is updated monthly and the charts automatically update themselves. The problem is that when the data is updated on the charts, the plot area reverts to some default size which does not take advantage of alot of the chart size. I don't want to go to each chart every month and manually increase the plot area. Any ideas? Thanks. Jeff G |
All times are GMT +1. The time now is 07:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com