Excel Chart X Axis Values

Question

I'm trying to create a line chart in Excel with the following values from my sheet:

(0,100) (1,90) (2,80) (4,70) (8,60) (16,50)

The problem I can't work around is that I want the 0, 1, 2, 4, 8, 16 to be both labels on the x-axis of my chart as well as the values (i.e., the 4 should be twice the distance from 0 as the 2, the 8 twice the 4, etc.).

When I create the chart in Excel all x-axis values are equally spread.

Is this even possible in Excel?

Answer 1

If you use the series (0,1,2,4,8,16) as Horizontal Category (Axis) Labels, Excel will always equally spread the values unless you select one of the Scatter chart types.

After selecting a Scatter chart for your data, you will see that your x-axis labels will spread according to their values.