up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
83% accept rate
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
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.