+ Reply to Thread
Results 1 to 6 of 6

Why do my graphs keep getting bigger?

  1. #1
    Registered User
    Join Date
    02-08-2017
    Location
    Oregon
    MS-Off Ver
    Office 365
    Posts
    6

    Why do my graphs keep getting bigger?

    I have some spreadsheets that I update daily.

    Why, after a couple of months, do the graphs I have created keep getting bigger and bigger, until they no longer fit my screen?

    Why do the fonts on my graph's labels keep getting smaller?

    Thanks,
    David

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,645

    Re: Why do my graphs keep getting bigger?

    Hard to tell without seeing your file. A chart shouldn't change its overall size, even if more data is added to it. I have seen that kind of behavior with ActiveX buttons in some situations but never built-in Excel elements like charts.

    Can you attach your file? Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-08-2017
    Location
    Oregon
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Why do my graphs keep getting bigger?

    I could attach a file, but this happens with every Excel file I've ever created, going back probably a decade, well before Excel 365.

  4. #4
    Registered User
    Join Date
    02-08-2017
    Location
    Oregon
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Why do my graphs keep getting bigger?

    I'm attaching, hopefully, a spreadsheet where my graphs keep getting bigger until they extend past the right side of my screen.
    Attached Files Attached Files

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,645

    Re: Why do my graphs keep getting bigger?

    I have experimented with your graphs by adding a few years' worth of fake data and it had no effect on the size of the graphs or fonts. I have been using Excel for at least 20 years and have never seen what you are describing. I am taken aback that you say this happens with every Excel file you have ever created going back a decade.

    What other versions of Excel, what OS? And also, what kind of computer/monitor setup are you using? I assume you have not been using the same hardware going back a decade.

    When you say it extends past the right side of your screen, does the chart extend past more columns to the right? The one you posted extends to about column Q--are you saying that it goes out to some column way to the right like AA, or just that this is a display artifact of some sort? Screenshots are usually not helpful but in this case it would be very helpful if you could post a screenshot showing the chart going off your screen.

  6. #6
    Registered User
    Join Date
    02-08-2017
    Location
    Oregon
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Why do my graphs keep getting bigger?

    Yes, this happens to me all the time.

    I've had all the versions of Excel, back to at least Excel 95 (or maybe it was Excel 93 -- I don't remember.)

    Yes, the chart extends past the colums to the right.

    Every few months I have to resize the chart to bring it back to a view on the screen.

    This has happened for several different computers of mine and for several different versions of Excel.

    The font sizes in labels keep decreasing too.

    Obviously I don't have a screen shot "showing the chart going off my screen." It doesn't happen all at once or at any particular time, it just happens over time.

    This is why I will probably not resubscribe to Excel 365 -- because of these kinds of ridiculous bugs.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If any value bigger than 1 then
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-01-2016, 07:26 AM
  2. Replies: 1
    Last Post: 10-24-2014, 12:20 AM
  3. multiple graphs on one screen and moving graphs
    By mufan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-12-2014, 04:49 PM
  4. Replies: 4
    Last Post: 07-15-2013, 05:42 AM
  5. Replies: 2
    Last Post: 03-14-2006, 02:04 AM
  6. Automatic Graphs/ Dynamic Graphs
    By DanielWalters6 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-24-2006, 05:35 PM
  7. [SOLVED] Workbook Bigger and Bigger
    By Ye Yint Win in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1