how would you go about making a masturbation spreadsheet?
I made one for 2015 in Excel, but since I'm shit at Excel it didn't turn out very well. So I'm trying again for 2016. I want to be able to make a chart showing how many times I masturbated each month throughout the year. Any ideas how I should set this up? I'll post a pic of my 2015 version.
Here's 2015. It's in danish but it shouldn't make a difference. (The "i alt" at the top is the total for the entire year and then there's also one for each month. The months just continue downwards)
Here I don't have every date though, only the ones I actually masturbated, and the number is how many times. So I couldn't figure out how to make a chart from that, how should I set it up for 2016?
If I remember correctly if you plot your data in a scatter graph it will scale correctly for unused dates.
If you want something more advanced like faps per month you'll either want to make a pivot table or a list of months then an appropriate expression to sum the values based on date range for each month.
Try marking the data and hitting a charting view and should display it automatically.
you need a column dates and column with values, it should automatically pick it up and display it.
if its wrong you can just switch the axis
If I do that it just creates a point for every single date instead of month.