+ Reply to Thread
Results 1 to 1 of 1

Axis labels vanish if I try to use their full range after a seemingly arbitrary limit...

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2010
    Posts
    1

    Axis labels vanish if I try to use their full range after a seemingly arbitrary limit...

    Hi guys!

    I have a weird issue with the horizontal labels on a plot - I have a table with 5059 rows but if I try to use all the labels, the plot only shows the first one. However, if I restrict the label range to the first 4828 rows, it shows all the labels up to there. If I type in 4829, boom, labels vanish. The labels are calculated according to a fairly simple formula, but the formula is the same for the first 4000 rows as well as for the last 1000, so I have no idea why it doesn't work. I have similar plots with 6k and 9k rows, with the same formula, and those work. I've even copied this out to a separate workbook just in case it's something weird, and I've tried removing the label on the 4829th row (also tried just making it plain text), but to no avail.

    Does anyone have any idea what's going on?

    I've attached a workbook with the offending data and plot in case you need it - any help you can give me will be appreciated. Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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