I need to plot these values against time. Y are prices of an stock index and X are given in dates. When I highlight both the columns and insert line graph. The graph turns out wrong. Not sure why. Need some guidance.
Y
55.86
56.4831183
56.79287172
56.15020358
56.54651172
57.17813626
57.74751614
57.99484875
57.81842842
57.82525099
X
19620702
19620703
19620705
19620706
19620709
19620710
19620711
19620712
19620713
19620716
The graph looks like this: