Recently I posted a graphic showing words per day. (I’ve used it before: you can see posts here and here.) It’s part of my musings about writing velocity and general “feeling like an author.” I’ll tee up a few posts on that in the future, but for now I wanted to provide a Google Sheet, called Writing Progress, open for anyone can copy, then modify on their own account as they see fit. Once you’ve got it you can try exporting it to Excel (see pix at end of post.) The Microsoft version needed tweaking, especially on the timeline sheet, with might not be worth fixing vs. recreating, provided you have basic pivot table skills.
The goal for the sheet is twofold. First, to share something folks have asked about, because that’s what some authors do.
Second, it does for free, and with little grief, that thing that I paid Aeon Timeline $ome $illy $um of $50 to have and then to puzzle over. It integrates with Scrivener, which I (very reluctantly, see here, here, and here) use, but has been too much trouble to set up and keep linked. And if you don’t use Scrivener, I don’t see much reason in buying Aeon.
So head out to the Writing Progress sheet and see it for yourself. (No login required to check it out, but I’m guessing you need Google Drive to copy it.)