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?

## Best Answer

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 charttypes.After selecting a Scatter chart for your data, you will see that your x-axis labels will spread according to their values.