I've plotted a graph with temperatures on the X-axis. Due to the nature of my data the temperatures are weird sizes like 29.20195 etc.
What I want to do is just have it display 25-155 in increments of 5 degrees on the bottom axis instead of displaying 29 30 32 34 etc like it currently is. In the 'Axis Options' I managed to get rid of the decimal places it was showing and change the interval but it still starts at 29 and ends on 149. I'm sure in the last version of Excel you could simply give it a range to show numbers from (ie 25-155)?
Thanks
edit: Also, I'm sure there used to be an option to add a title (at the top and for each axis) when you right clicked that chart but now there isn't
What I want to do is just have it display 25-155 in increments of 5 degrees on the bottom axis instead of displaying 29 30 32 34 etc like it currently is. In the 'Axis Options' I managed to get rid of the decimal places it was showing and change the interval but it still starts at 29 and ends on 149. I'm sure in the last version of Excel you could simply give it a range to show numbers from (ie 25-155)?
Thanks
edit: Also, I'm sure there used to be an option to add a title (at the top and for each axis) when you right clicked that chart but now there isn't

Last edited: