0

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:

enter image description here

1
  • Looks fine to me when I select a Scatter plot. Nov 14, 2013 at 8:05

2 Answers 2

2

Select your "Y" column only, and then insert the graph:

enter image description here

Then right-click the chart and select "Select Data...", and the Select Data Source dialog will open:

enter image description here

For the Horizontal Axis Labels, click "Edit", and this will open an Axis Labels dialog:

enter image description here

While that's open, go back to the spreadsheet and select your "X" column. This will populate the dialog box with a range.

Hit "OK" to close that dialog, and then hit "OK" again to close the Select Data Source dialog.

That should do it:

enter image description here

3
  • This treats the X-axis data as text labels, rather than dates or numbers. Note that the gap between 02 and 03 is the same as the gap between 03 and 05. Nov 13, 2013 at 19:28
  • @Scott I'm not sure what you're getting at? "Labels" are always going to be "text". I'm just using the example data provided. The problem with the graphic that was there, was because I accidentally included the actual "X" cell, so it was the first X data point. fixed... Nov 13, 2013 at 19:40
0

You need to use the X-Y-plot diagram (screenshot from danish version of Exell, but you should get the point).

enter image description here

1
  • tried this already. not able to get the date in the X column.
    – lakshmen
    Nov 13, 2013 at 18:51

Not the answer you're looking for? Browse other questions tagged .