Forum Discussion
Plotting date and time on the X axis
I have variables on the Y axis that I want to plot against date and time of day. My data input format is mm/dd/yy hh:mm (10/30/24 20:47). When plotted on a line chart, all of the variables are shown on the same date regardless of the time. How do I get the chart to show the time of day?
Your chart is a line chart. You have two options:
- Leave the chart as a line chart. Double-click the x-axis and under Axis Type, select Text Axis. Each time will be displayed separately, but not necessary in the correct proportion.
- Change the chart type to XY Scatter Chart.
- Leave the chart as a line chart. Double-click the x-axis and under Axis Type, select Text Axis. Each time will be displayed separately, but not necessary in the correct proportion.
