Thread: Changing category axis

I have a line chart with the categories: 2, 3, 10, 20, 30, 40, 50, 75, 150, 500.

What I'm trying to do is get the x-axis to reflect the distance between each category rather than having each number spaced equally across the axis.

For instance, the 2 and 3 should be right next to each other, but the 3 should be farther away from the 10. Of course I can get the graph to look right using a normal scale, but I only want the specified categories to show up on the axis.

You need an x-y (scatter) chart instead of a line graph.

Right cilck the chart and go to "chart-type"

HTH