Forum Discussion
Book reading speed to graph
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 ...
mtarler yes, you did it, It looks just like i wanted! Thank you
But now whenever i change it somehow, the calculations go wild (#value or #name). What to do, when i would like to add a row to the table of books; or take your concept to different excel sheet?
But now whenever i change it somehow, the calculations go wild (#value or #name). What to do, when i would like to add a row to the table of books; or take your concept to different excel sheet?
how are you changing it? The data table will automatically include all the books across the top and dates accordingly on the left. The data section is based on those headers and may need to be filled down/right as needed. The plot may need to be re-created (or editted) when you do fill down/right. I could create custom names that would autoscale the length of the data but that will not solve the issue if you add data sets (i.e. books).