Manually Select Excel Chart Axis Values?

[HUNTER.P]

I've been clicking, and searching all the menus for ages now and cant find any tool to help me. Basically I need my graph to show specific Y Axis Values (0, 17.3, 26.2, 34.9, 43.4, 52.2) rather than the automatic generated values (0, 10 , 20, 30, 40, 50, 60)

My Graph

Example Graph (showing specific y values)

 

[UnworthyBean]

You can it to an extent, Right click on the axis and fiddle around with axis options.

For your printed example (X axis) you'd want the Maximum to be 87.5 and the Major unit to be 17.5.

If you fiddle around with those options, You might get something close to what you need.

Also - This is all based on MS Excel 2010.

 

[Sunbed]

Structural Engineering???

 

[HUNTER.P]

Well I'm actually studying Electronic Engineering, but all the engineering courses do similar base modules which apparently we will need to know