ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Chart being trashed after 5th build (https://www.excelbanter.com/excel-programming/300247-chart-being-trashed-after-5th-build.html)

Don Wiss

Chart being trashed after 5th build
 
I have a chart that is created by a macro. Data, scaling, titles, axes, and
textbox note, are all changed by the macro. But for some reason the chart
has now taken on a characteristic that makes it unusable. On the fifth time
that it is created the X and Y axis scales, and the X-axis label, turn into
a microscopic sized font. The plot area enlarges to fill the space. This
happens whether I'm changing the chart each time, or simply recreating the
same one five times in a row. It is always the fifth time. I see no easy
way to set everything back, so I don't save the workbook and load up one
where the chart hasn't yet been destroyed. What is going on?

Don <donwiss at panix.com.


All times are GMT +1. The time now is 03:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com