1

I am using Excel 2016 for Mac to produce a time-based chart to record two temperature. One column for the date and time, two more for temperature readings. However, Excel appears to be ignoring the time component of the date and plotting all points at 0:00 of whatever date value in the cell.

I have formatted the A column to be a Date with the appropriate time format. I have tried screwing around with the axis options, including explicitly setting the column to a Date axis. I cant seem to get the time values to plot. I have noticed that in the axis options there is a section for Units but that doesnt have an option for minutes or hours - only days, months, and years.

How do I get Excel to plot the points at the appropriate time?

enter image description here

1

An Excel line chart using a Date scale has a Date-only scale. The resolution is one day, so you can't distinguish between separate times in a day.

Instead, make an XY Scatter chart. You can format the series to have a line so it looks like a "line" chart, but the X axis can plot dates and times continuously.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.