|Here's the tricky part, and only you can decide how to deal with it.|
Your charts shows the last cumulative percentage through the end of the month because you have the SUM formulas in Rows 6 - 8 for the entire month, which in turn calculates a percentage for every day based on the latest data available.
The first thing that came to mind was to suggest an IF formula that would not calculate a percentage for days beyond the current day with data, since any days beyond the current would have 0's in Rows 3, 4, and 5.
=IF(AND(F3=0, F4=0, F5=0), 0 ,IF(ISERROR(etc...)
This would force a 0 into Row 9 which would eliminate the percentages that get carried forward for days beyond the current day.
However, if the most recent day (or days) happen to contain 0's in Rows 3, 4 and 5, then you would get a 0 percentage, when I think you really do want the latest percentage, since it's a valid number up until that day.
One way around that might be to add a Row where you could use an X or some other character to tell the formula that even if there are zeros in Rows 3, 4 and 5 on that day, still calculate a percentage.
In other words, if you have numbers that give 65% up to Day 8 but 0's on Days 9 & 10, I assume you want 65% charted through Day 10, but nothing after that. With a Row that contained a "key", such as an X, your formula might be something like:
=IF(F(your key row) = "X", IF(ISERROR(etc...)
The user would simply need to put an X in the column for the current day in order to have the percentage calculated.
Does that make sense?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.