![]() 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? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |