Combine data from several rows in one series in scatter plot

I have data points in several rows, which all have same X values (row 1). I would like to group some of the series so that when I plot them in a scatter diagram, I can manipulate this "multiple" series as one series (e.g. adding a trend line). In other words, I would like to plot the points in row 2 as one series, 3-4 as another one.

This illustrates my data:

X values		x1	x2	x3	x4
Group A		2	2	2	2
Group B	Subgr.1	3	3	3	3
	Subgr.2	4	4	4	4

This should be plotted as two series (Group A and B), where Group B contains y values for both subgroup 1 and 2, i.e. the Group B series will plot two points for each x value.


How can I do this? I don't want to make a new table with all the Group data point in one row, (as shown below), as this only solve my problem for this particular grouping (I need to change grouping of series in other charts, so that all points in Group A and B should be seen as ONE series for example).

X values	x1	x2	x3	x4	x1	x2	x3	x4
Group B	3	3	3	3	4	4	4	4

^^ I don't want this!!


I found this answer which seemed to help, but I get a error message saying that the formula I typed is wrong (the y-values in the data series range) if I try doing it: http://www.excelforum.com/excel-char...-1-series.html

Hope someone can help! Thanks.

Update: I found one way of doing it; by adding a semi-colon between marking each row in the data series value box, I can add different rows. However, to plot the extra points, I have to manually add the x values an extra time for each extra row of y values. If someone have a more smooth way, I would stil highly appretiate it!