Get Excel to use column of numbers as labels (equally-spaced on x-axis) instead of as x values (x-axis co-ordinates)

Question

It could be an easy question but I can't find a proper way to accomplish my task.

I have a simple graph and all I want is to show the X values I wrote in the first column at the bottom of the graph (in X-Axis label). It's ok to have some kind of "scale marks" (20 - 40 - 60...) on a 1-100 scale, but I need those values to be shown.

In this Picture you can see what I get with a scatter graph (I've tried other types but without success). Values have a "gap" of 20 but my X values (first column) are not shown in the X-axis.

How can I add them? Thanks in advance

Answer 1

Add a column of zeros to the data.

The first chart below has your original data; the second includes these zeros, which appear along the X axis.

In the third chart I've added data labels below the second series of points (temporarily colored orange to match the series). These show the Y values, all zeros.

In the fourth chart I've formatted the data labels to show the X values instead of the Y values.

In the fifth chart, I've used the custom number format " " (double quote, space, double quote) for the X axis tick labels. This maintains the spacing below the chart for the labels, where using None for the label option would have squashed the chart and overlapped the data labels we've added.

Finally I've restored the data label font color, and formatted the added series so it uses no line and gray cross markers to indicate the position of the other points projected to the axis.

Answer 2

Ok, it was simple indeed. Scatter graph and similars can't display the values as I wanted.

Solution: Left click on graph -> change type -> Line Graph -> Here you go