need help with an excel graph

[Jonnybmac]

been looking on youtube but cant find anything. most tutorials show a graph with a value on 1,2,3,4,5,6... but how do i change the horizontal axis values so they dont display the actual value along the bottom but increments of 10's?

e.g: 10 20 30 40 50

with the values plotted between them? like how the vertical axis is

 

[shroomz]

right click the x-axis, format, set the maximum & minimum range, set the major/minor intervals

 

[adolf hamster]

Have you looked at the axis properties? Right click on the axis itself then format axis, you can then set manual axis properties

 

[Jonnybmac]

ive already looked at that, for the vertical i get the box on the left which i assumed and as you explained and confirmed does the job, but when doing the same on the horizontal i dont get the option as shown in the right hand box

 

[muon]

Check the format is numeric for distance. Otherwise excel can't understand.

 

[Jonnybmac]

the format is set to number. if i upload it to googledocs then it looks right, just not in excel

heres a link

https://onedrive.live.com/redir?resid=165346B2E83FD3C6!349&authkey=!ADzaaZQ-QcVci30&ithint=file,xlsx

 

[muon]

Scattergraph with trend line then, or if you want, a linked line.

 

[Jonnybmac]

awsome, sorted! thanks for the help!