Oct 18 2021 05:39 AM
I am trying to keep track of my book reading and i want to know aprox how many pages i read per day. I have similiar data to what i have attached and i would like to plot it on a chart, to something like this:
So i can see total number of pages per day (week,month) and different stack colours for individual books i am reading during that time. Pages per day is calculated as an average (total number of pages/days).
Can someone help me with the graph, since i cannot make excel do it without too much hassle (too much formulas and vlookups)?
Thank you!
Oct 23 2021 02:15 PM
If identify each book on the chart I don't think that will be easy task even for pros. You may have hundreds of books totally, I don't think we shall show all of them, that will be mess. Perhaps only books were read during filtered period of time, thus dynamic labeling.
Oct 23 2021 05:44 PM
@Metchik not sure all that you want or going for but see the attached as a starting point. I gave you time steps (days) so you could change the time periods from days to weeks (7 days) or something close to months (30 days). I also added a start and end date to filter the relevant range you want to look at. But the part i was most unsure about was if you wanted to show pages/day regardless of the time period or the total number of pages for each time period (based on the average). i went with the later so if you are looking at a week and the book ended 1/2 way then it took # of days in that period when you read * your avg pages/day at the # of pages read during that partial week.
Oct 25 2021 01:14 AM
Oct 25 2021 01:15 AM
Oct 25 2021 08:10 AM