Since Excel 2013 there has been a limit of 255 on the Chart Axis Interval value, this needs increasing again as per Excel 2010 and earlier as it is currently impossible to control sensible axis labels in large datasets - thanks.