I wanted vertical lines to go up along the graph ie X axis (have I got the axis correct? ( x is horizontal?) so I could take readings...
You have the axis right, but it's a little tricky talking about the grid lines. The x-axis grid is perpendicular to the x-axis, not parallel, so the x-axis grid lines are vertical. That means that the y-axis grid is horizontal.
Just tried X Y scatter but by log values changed from 1.47 ...etc to 1, 2, 3. 4, etc any ideas?
That's a good start, but unfortunately Calc doesn't guess correctly at the data ranges for the x values. You have to go to Format > Data Ranges > Data Series and assign the x values to the range
The X-Y graph should look like the screenshot below. I've made the X-axis blue and the Y-axis (and y-grid) red.
I should emphasize: I don't know which type of graph is right for your purpose, but it is rather unusual to plot pairs of values on a line plot. In this case the difference is subtle, but you can see that the x-y plot shows that the x values are not distributed evenly, where the line plot makes them look as if they are evenly distributed. If you're trying to interpolate (take readings) based on the graph, you would get the wrong reading from the line plot (although the difference here is small).