# How make this graph in Excel?

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

-
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

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.

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

-

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.

-