I have attached my workbook to this post, so you can look at it. I keep track of how many words I write for my novel, I have my overall goal for the story and one for the week. Base on the start date and end dates, for both goals, it tells me how many words I need to write to accomplish the goal on time. Off to the right of this information I have two pie charts one for my overall goal, and one for the weekly goal. They slowly become unfilled as I get closer to my goal.
I use the same set up for both weekly and overall goals, which makes my weekly pie with only about a quarter left until it is gone. I don't want this, I want it to be full from the begining. To do this I need to be able to put exactly how many words I want for the week. Example Right now, I put 17000 as my overall words for the week, and I have 13000. Leaving me 4000 left to my weekly goal. This is why my pie is mostly empty. Instead I want to put in 4000 for my goal, but not sure the formulas I would need to do. Please check the workbook, to see what I mean. Any help would be great.
Thanks
Tim
P.S. I know by changing my world tally range would do this, but I don't want to have to go in and change that every week. I want it based on the dates I put in the dates at the top.
Bookmarks