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!
Bookmarks