How do I plot a point off the x axis scale on Microsoft Excel?

Question

As an example, I have the following data (missing values and one that deviates from the 0-100 scale) that I'd like to plot as a line graph. I'd like the x-axis scale to read 0-100 in 10 increments of 10, and the data point for 61.9 to plot a little to the right of 60, however you can see that the x axis reads 60, 61.9, 70, in equal increments.

My data and graph with the issue

How do I stop this from happening?

Answer 1

Arrange the data as follows and plot the graph as usual (You needn't necessarily put those gaps in between readings). You will get a graph like this.

In the above graph, the X-axis is formatted automatically with an increment of 20, all the way upto 120.

Now, to plot the X-axis with an equal increment of 10 upto 100, follow the following method:

• Left click on any value in the x-axis to select that particular axis of your graph. Now right click anywhere on the selected portion to get a menu like this:

• Click on Format Axis which will open this up:

• After clicking the radio button that says Fixed, change the values of Maximum and Major Unit to 100 and 10 respectively, as marked in red and click Close

• That's it. You'll have it. See this:

I hope this helps :)