Question: how to change time axis in excel?
Answer: Click on the chart to open the Format Chart Area Pane.
Click on Chart Options and select Horizontal (Value) Axis.
Click the Axis Option Icon.
Open the Axis Options dropdown triangle.
Make changes to the Bounds, Units, and so on to adjust the time-scale to display the chart in the manner you wish.