Right click at the X axis in the chart, and select Format Axis from the context menu. To display the date and time correctly, you only need to change an option in the Format Axis dialog.ġ. And in this article, I introduce the way for how to show the date and time on X axis correctly in the Chart.Ĭreate a chart with date and time on X axis correctly But in some cases, when you create a column/bar/line chart based on a series of date and time, the X axis of the chart may be shown as below screenshot.
In Excel, we usually insert a chart to better describe the data.
How to create a chart with date and time on X axis in Excel?
