I have created a scatter plot in Excel, and I'd like to be able to draw its center of mass (i.e. the point whose coordinates is the average of each series).
I am currently doing it using this trick:
- I add the center of mass as an additional point to my series, using
average
function to compute its x- and y-coordinates. - I generate my scatter plot using the button "Insert > Scatter plot"
- I identify and color that point in a different color.
This works fine, and is easy to do when I have a small number of points. But it is much more tedious when I have to deal with a large number of points (e.g. 5000 points).
Therefore, is there any more efficient way to do this? I searched a lot for this, but I was not able to find anything.... :(
Please let me know.