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

Question

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?

score 6 · Accepted Answer · edited Mar 22 '18 at 07:01

6

You can achieve it by using a scatter graph:

edited Mar 22 '18 at 07:01

fixer1234

28,064

answered Mar 21 '18 at 18:39

cybernetic.nomad

5,951
15
26

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

1 Answers1