Creating series for bubble chart from a table column

Let us suppose that I have to create a bubble chart from the following data:

The first column is for labeling data.  Data for X and Y axes are taken from second and third column. The fourth column is used to size the bubbles. If I use just the first four columns, no problem. Quite easy to do. But now suppose that I wish to use series of data, that is, I wish to color bubbles by using three different colors. I have, in fact, a fifth column that tells me to which group/series a record belong to.

I cannot find a way to do it. Any hint? Just consider that I have a big table and that records change because are real data taken from an external source, so manually splitting the table is NOT a solution. I need some automatic approach.