help me make this excel graph

Factual Questions
1

OK - so can somebody tell me how to create a graph where the x axis reads 1,2,3,etc and the y axis is in values of 10s? Also, how can I put a value of 1,58 and 9, 53 on the same excel graph? Thanks.

2

ok, I’ve figured out how to get the x and y axis, but I can’t figure out how to get 58 and 53 without changing the y axis values to 50-59.

3

Put your source data for the x axis in one column, right next to that put your Y values in another column.
i.e.



X Values | Y Values
    1        58
    4        56
    7        54
    9        53

Select the data, click on graph,
Build your graph, then right click on the axis and select Format Axis.
From there click on Scale.

From there you can override the auto features that set the scale.
Uncheck Minimum and type in 0
Uncheck Major Unit and type in 10.
(Removing the checkmark turns off the auto feature)

If you need more detailed help let me know.

E3