I have a spreadsheet tracking weight loss efforts of a group. I find it motivating to look at the data lots of different ways. One thing that occurred to me that might be interesting is creating a sort of bell curve for each of us showing the distributions of our weekly loss/gains centered around 0. So the line is higher at -1 the more times you lost 1lb that week and so on. Different people’s scales sometimes track half pound or 2-tenths as a precision.
How can I make this happen? I’ve got various types of line charts, but I’m not sure where to start here. I am effectively wanting the value in the cell to be the x-axis, the count or proportion of how often they occur out of 100% as the y-axis, and I don’t want to have to sort the raw data set which is by date.