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 have CSV with the following data

enter image description here

There are 500 rows of this series. However, I need to plot whatever on A column as horizontal axis and B column [0..499] as vertical. If possible I would like to label horizontal axis values on each 10.000. This is what I want to achieve

test

Sample data from [200...499]

share|improve this question
    
What version of excel are you using? I know for sure this can be acheived in Excel 2010.. –  Richie086 Dec 20 '12 at 22:50
    
2010 it is! My hair goes white... –  Pablo Dec 20 '12 at 22:52
    
I've also updated my post with sample data. –  Pablo Dec 20 '12 at 22:58

2 Answers 2

up vote 3 down vote accepted

EDIT: Complete rewrite.

Select the two columns of data, with the first column being the X axis. Then insert a scatter chart.

Scatter Chart

(And here I thought the line graph was the easy one.)

If you want to display the numbers as kilo-ohms, I suggest you divide the numbers in the column by 1000 and use the custom number format: 0" kΩ"

Even better, don't divide the original data. use a custom number format of 0," kΩ" where the comma after the zero removes three zeros to show thousands. In the same way 0,," MΩ" has two commas, so three sets of three zeros are removed, showing millions.

share|improve this answer
    
Sorry, but that's what I've tried already. It doesn't give me A column as horizontal axis! When I try to specify column B in horizontal axis, I get whole chart screwed... –  Pablo Dec 21 '12 at 0:21
    
If you are sure about solution, could you plz post a screenshot which looks similar to the graph above? To me it doesn't look like I can achieve it in Excel, just because my A column data, which should rest on horizontal axis, doesn't have exact same "ticks" as it should have. So somehow Excel should take all data and approximate for 10000, 20000, ... 50000. Moreover, it should somehow limit horizontal axis up to 50000. In the A column there is even value with 2000000, which should be dropped out. Do you still think Excel can make it? –  Pablo Dec 21 '12 at 0:34
    
Sorry, I was confused as to which way around you wanted it. I've rewritten my answer. –  Hand-E-Food Dec 21 '12 at 1:35

Select Column B, go to Insert tab, click on the line graph.

When the graph is in, right-click on it, click 'select data', click on 'edit' on the right (below horizontal category axis label), select column A, click OK.

share|improve this answer
    
The line chart is what the OP got, where categories were shows by counting numbers 1, 2, 3, etc. Only an XY Scatter chart will use numerical values from the data as X values. –  Jon Peltier Sep 5 '13 at 13:26

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.