How to Create a Chart with Date and Time on X Axis

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".