Excel graphs resizing (Excel 98)

Topic

New Reply

I have a worksheet with several excel graphs which resize when excel is closed. I have tried Format Chart Area and Don’t move or size with cells and the titles; and Michrosoft Technet Q186931, Chart Is Reduced to a Small Size After Formatting Legend; however, this did not seem to resolve the problem. Does anyone have any other solutions to this problem?

Reply | Quote

Replies

Hi sschade,

This is perhaps more of a workaround than a solution, but you could simply add a few lines of code to a ThisWorkbook_Open event to size the chart the way you want it. This way each time you open the workbook, the chart will be returned to the desired size.

Reply | Quote