How to create a chart with date and time on X axis in Excel?
The Chance to Change Your Working Mode
In Excel, we usually insert a chart to better describe the data. 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. And in this article, I introduce the way for how to show the date and time on X axis correctly in the Chart.
Export graphics (Pictures/Charts/Shapes/All Types) from workbook to a folder as Gif/Tif/PNG/JPEG
|If there are multiple type of graphics in a workbook, and you just want to export all charts across worksheet to a folder as gif of other type of picture, you can use Kutools for Excel's Export Graphics utilty, which only need 3 steps to handle this job . Click for full-featured 60 days free trial!|
|Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.|
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To display the date and time correctly, you only need to change an option in the Format Axis dialog.
1. Right click at the X axis in the chart, and select Format Axis from the context menu. See screenshot:
2. Then in the Format Axis pane or Format Axis dialog, under Axis Options tab, check Text axis option in the Axis Type section. See screenshot:
3. Click Close or go back to the chart, then then date and time data has been correctly display in the X axis. See screenshot:
Tabbed browsing & editing multiple Excel workbooks/Word documents as Firefox, Chrome, Internet Explore 10!
You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. Click for free 45-day trial of Office Tab!
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 5 months agoThis is not OK. It does not show correct order by time just puts the timestamps there as a text in equal distances.