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 do this kind of graph in Excel, but nothing so far. I don't find anything like it, but it has to be this way, not bars.

starter 22,58 20,76 7,1 37,93 68,42 professional 72,41 72,73 71,43 70,83 82,86

enter image description here

share|improve this question
    
I don't understand your data set. Are they pairs (22, 58) (20, 76) ... or individual numbers (20, 55, 20, 76, ...)? –  Rhys Gibson Dec 19 '11 at 21:14
    
@Rhys: I think these are numbers using , as decimal seperator, so 22.58, 20.76, 7.1 ... if using . as decimal seperator. –  schnaader Dec 19 '11 at 21:19
    
Ah, european numbering. I get it now. –  Rhys Gibson Dec 19 '11 at 21:24

3 Answers 3

up vote 2 down vote accepted

That is called a Scatter plot, which is one of the default options available in Excel. Select your data source(s), go to the Insert tab and in the Charts group select Scatter.

share|improve this answer
    
This does not excatly create the graph, since scatter does not allow the x axis to use groups/series. –  Norfeldt May 3 '13 at 14:42

I know the question has been marked as answered, but I would still like to link to this post where the answer also provides a guide on howto actually do it in excel.

share|improve this answer

Start with a range with "Starter" and "Professional" in the first column and two zeros in the second. Insert a bar chart. This provides labels, but the zero means the bars do not show.

In another two columns, place 1 for Starter and 2 for Professional in the first column, and the Y values in the second. Copy this range, select chart, use Paste Special (categories in first column).

Right click on this new series, choose Change Chart Type, select XY Scatter. Again right click on new series, choose Format Data Series, select Primary Axis where given a choice.

share|improve this answer

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.