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
Bookmarks