Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 5 down vote accepted

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .