I have a large data set with numerous high values (0-1.25 million) and am wanting to place these values onto the x axis of a chart. When placed onto the x axis this data appears, but it looks messy and confusing as the numbers are too large. Is there a way to change the x axis to values such as 0 , 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1.0 (units millions). It appear this option is only applicable for the y axis?
Solved by T. L. in 27 mins