Scatter graph with multiple XY values for each legend series

Hi there,

I have a table of one block of data. I'd like to create a scatter graph using three of the columns but can't work out how to automatically generate the chart without entering each entry manually individually under different series. One of the rows repeats for each entry then has X and Y data in another column. For example:

Name	Throw Distance	Throw Accuracy
Sam	10	2
Sam	11	3
Sam	11	2
John	12	-1
John	14	1
John	16	3
George	8	-2
George	9	-0.5
George	10	0.5

Where each persons name is a series, the throw distance is the horizontal axis and the accuracy is the vertical axis. The table will have data added regularly so I'd like the chart to add new data by searching for the name and adding it to the relevant series with the scatter dot in the relevant X & Y place.

Hopefully this makes sense and looking forward to any advice...

Many thanks

This may not be what you want, but I can plot one series at a time.

First I made a chart manually just to see what the final results should look like. The chart under the data is the working chart.

For convenience I made a dropdown box in cell A15 where you can select the name.

Then I made two named ranges for throw distance and throw accuracy:
T_D =IF(Table1[Name]=Sheet1!$A$15,Table1[Throw Distance],NA())
T_A =IF(Table1[Name]=Sheet1!$A$15,Table1[Throw Accuracy],NA())

Both of these were entered using the name manager and entered as an array formula. What T_D says is if you find the name in Column A, use the value in the Throw_Distance column, otherwise use NA() (which does not plot). T_A is similar logic.

Then make a an X-Y scatter plot using some fixed values. Then right click on the chart and select Select - Data. Click on the series. Edit the series. Click in the series name box and then select Call A15 - this will change the name of the series when you select a new name.

For the X-Values, type in T_D in place of the fixed values (keep the sheet or book name and apostrophe)
For the Y-Values, type in T_A in place of the fixed values.

When you select a new name, the named ranges will change and so will the plot.

I can't think of a way off hand to make all there series at once without resorting to VBA.