


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. I have found - especially since I upgraded to 2007 when MS did away with the chart wizard - that I am frequently using the Select Source Data dialog to fix Excel's faulty guesses that it makes on chart creation.How to create a chart with date and time on X axis in Excel? (this step is optional, you don't need to roll your eyes or grumble in order to get this to work).Ĥ) Go into the Select Source data dialog and:Ĥa) Select the one data series and edit the ranges so that there is nothing in the "name" field and the "values" field is pointing to H2:H9.Ĥb) Select "edit" above the horizontal category axis data and point this field to A2:A9. I got something very similar to your picture in post 1.ģ) Roll my eyes and grumble under breath because, once again, Excel completely misunderstood my desired source data ranges. Here's what I did:Ģ) Insert -> line chart -> any regular line chart. Your sample file did not include your attempts at the chart, so it is difficult to know what you did wrong. But there must be a way to keep the formatting I want and get the graph displayed as I want. If I don't use time formats (hh:mm:ss) in the column on the right and instead just type in ordinary number values then it works. I have tried various suggested solution about changing the date to text etc. The axes are the wrong way around and the dates are not recognised, and I only get one value for the x-axis, like this:

Seems simple enough but I cannot get this to format correctly. I want to graph the dates in the first column on the left as the x-axis, and the calculated average from the column on the right.
