Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel graphs resizing (Excel 98)

    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?

  2. #2
    New Lounger
    Join Date
    May 2002
    Location
    Colorado, USA
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel graphs resizing (Excel 98)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •