Plot Area Changes in Charts

J

Jeff Gross

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plot Area Changes Automatically When Updated 3
controlling plot area 1
Plot area not printing correctly 3
Seemingly random plot area drift? 2
Display Data Table in chart but don't show plot area 2
Plot Area Automatically Expands in Print and Print Preview 2
plot area inconsistent sizes with VBA 2
Can I set up an area chart in Excel with stepped changes? 2

Top