How to chart a CSV time variable in a scatter chart

John D Lacey 0 Reputation points
2025-11-04T16:37:51.3733333+00:00

I have a data set (including TIME) in CSV format. When I attempt to plot that data, the TIME axis is 0

Microsoft 365 and Office | Excel | For home | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marcin Policht 65,465 Reputation points MVP Volunteer Moderator
    2025-11-04T16:42:55.6+00:00

    Make sure your TIME column is formatted as Time or Date (select the column → Right-click → Format Cells → Time or Custom).

    When plotting, use an XY (Scatter) chart instead of a Line chart. Line charts treat the X-axis as categories, which can default to 0.

    If needed, re-enter the times or use =TIME(hour,minute,second) to ensure Excel sees them as time values.

    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.