Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 4 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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.