This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have data showing time in column A and a number at each time in column B
I want to chart it. The times in column A are not evenly spaced but when I chart it they are evenly spaced.
That is the distance from 6:10 to 6:20 is the same as the distance from 6:20 to 7:00.
How can I get the time spaced according to the number of minutes between each time data point?
A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Excel has the concept of a date axis, but not of a time axis - they omitted to implement that.
The only chart type that can display times proportionally on the x-axis is the XY Scatter chart:
Thanks. This solved it.