How to make a legend out of a column in a scatter chart?

[RickArnold]

I have some data that I would like to plot on a scatter chart. Below is a basic example of the data I am using. I would like to have the Group as the legend, Days from Start as my X-axis, and Distance as my Y-axis. I know that I can add each group separately and select the appropriate zones as my input from the Select Data Source, but I have several thousand rows of data. Does anyone know how I can do this more easily? I am hoping not to create a VBA script.

Group	Days from Start	Distance
A
A	1	1
A	2	2
A	3	3
B
B	1.1	2.5
B	2.3	5
B	2.9	6.5
C	.9	2.6
C	1.6	4.5
C	2.5	2.3

<tbody>
</tbody>

 

[RickArnold]

BTW, the table evidently leaves a blank whenever a zero is in a cell.