When creating charts, it is common to have category as the X-axis. However, you may have time to have the date and time for X-axis. Please follow the steps below to create a chart with date and time as the X-Axis.
Step 1: Select the data range;
Step 2: Click the "Insert" tab from the Ribbon
Step 3: Select the "Clustered Column" chart from the chart list;
Step 4: You will get a column chart as below;
Step 5: To change X-axis: Right-click on X-axis, select "Format Axis" from the dialog window;
Step 6: In the "Format Axis" window, click the "Number" section;
Step 7: Select the format you like to have for your chart;
Step 8: If need to keep only date with no time, you need to select "Date" under the "Category";
Step 5: The chart will become the one below when you select the date format "2012-03-14".