Forum Discussion

Snoopdon's avatar
Snoopdon
Copper Contributor
Oct 06, 2020
Solved

How to get chart showing DateTime values for data points on the horizontal axis

Please see the attached Excel workbook. The data are Fitbit steps for dates/times for 3 competitors. I want to make a chart for these data. If I select all the data, I get the chart with one vertical...
  • HansVogelaar's avatar
    Oct 06, 2020

    Snoopdon 

    Change the chart type from Line to XY-Scatter with lines and markers.

    To make the chart more readable I set the text direction for the x-axis labels to rotated 90 by degrees, and I decreased the height of the plot area to separate those labels from the legend.

    See the attached version.

Resources