I want to create a simple time/temp chart.
I want to chart to show on the horizontal axis: 1 - 2 - 3 - ... (hours).
I have temp data on 0.35 - 0.69 - 2.5 - 9.06 - ... hours (not actual values, but just to give an idea to show an irregular pattern).
Currently, I get an even spacing between each tick (so I have ticks at these points: 0.35 - 0.69 - 2.5 - 9.06 - ... ) but I want to set these data points on an 1 - 2 - 3 - ... labeled X axis.
I am using Excel 2013.
How do I do this?
I'm sure this has been asked before, but I'm probably searching for the wrong keywords. Could somebody please point me to a previous similar question (or give a short explanation please) ?
I want to chart to show on the horizontal axis: 1 - 2 - 3 - ... (hours).
I have temp data on 0.35 - 0.69 - 2.5 - 9.06 - ... hours (not actual values, but just to give an idea to show an irregular pattern).
Currently, I get an even spacing between each tick (so I have ticks at these points: 0.35 - 0.69 - 2.5 - 9.06 - ... ) but I want to set these data points on an 1 - 2 - 3 - ... labeled X axis.
I am using Excel 2013.
How do I do this?
I'm sure this has been asked before, but I'm probably searching for the wrong keywords. Could somebody please point me to a previous similar question (or give a short explanation please) ?