How to make X axis into value axis instead of category axis in excel?

2

The problem I have is shown in the picture. Basicly I have data on the x axis, but the spacing between them is not uniform. So instead of puting '4780' in the correct place between '4000' and '5000' excel puts it in the same distance as all the others. This distrorts my graph, since it shuld be a straight line. Does anyone know a fix for this?

enter image description here

József Kiss

Posted 2018-03-21T15:31:14.057

Reputation: 23

I think the issue here is that you have plotted a "line" graph, right? See @cyber 's answer. You can click on the graph and choose "Scatter" from the Chart Type tab, and that line will straighten right out. :-) – Bandersnatch – 2018-03-21T22:29:41.530

Answers

3

You can achieve it by using a scatter graph:

enter image description here

cybernetic.nomad

Posted 2018-03-21T15:31:14.057

Reputation: 4 469

Asked: 2018-03-21T15:31:14.057

Viewed: 3 217 times

Active: 2018-03-22T07:01:01.093