Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .