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.

Possible Duplicate:
Excel axis problem

I jumped from an older version of Excel to the new ribbon interface and am stumped trying to make a simple graph.

I have a set of pair values that go something like this:

X    Y
1    .5
2    .4
3    .35
4    .33
5    .3
10   .2
15   .15
20   .1

When I plot a line graph I get the x-axis as if the X's are text and each one is a category. I would like to get the graph where the 10, 15 and 20 values are put in their proportional place, with gaps between them wider than between the first elements. I'm sure Excel must be able to do this but I can't find how in the new interface.

share|improve this question

marked as duplicate by Daniel Beck Nov 17 '12 at 11:10

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
Try a scatter chart with smooth lines, is that what you are after? –  Tog Nov 29 '11 at 12:13
    
"Gaps between them wider than the first elements": like a logarithmic scale? What would you have done in the previous version of Excel to achieve this? (Also are you now on Excel 2010 or 2007?) –  jay Nov 29 '11 at 13:56
    
Tog, add that as an answer and I'll mark it approved. I ended up figuring it out on my own but it's exactly what you wrote. –  greye Nov 30 '11 at 16:40
    
Use Tog's approach, XY Scatter Chart, but use markers with straight lines; do not use smoothed lines. Smoothed lines indicate data where none exists. –  Jon Peltier Dec 5 '11 at 15:11
1  
@pnuts - Yes and no. The markers should be enough. People will see the curved lines and give them more emphasis than deserved. Also in some cases, the smoothed lines will stray far beyond where data is even possible. –  Jon Peltier Feb 19 '13 at 13:12
show 1 more comment

1 Answer

Try using a scatter chart with smooth lines

share|improve this answer
add comment

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