Hey Chandoo! Love your site, you are the best. Have to admit, I take credit at work for having the best tools, and half the time it's because I'm using your tips and templates. Anyway, here's my issue...
I'm using your template for graphing the burn down chart. My actual hours are dynamic -- (3rd column) a SUM function based on individual timesheet in the same file. I was able to use a function to make sure that any cells with a "0" value are 'blank' and not '0'. However, even with the empty cells in the 3rd column, my entire 5th column for "balance Actual" still populates all cells. The issue here is that the graph line for 'balance actual' is fully built out -- it shows as a long plateau based on the most recent calculated figure.
How do I get the balance actual to graph properly? For now, my work around is clearing out the formula from the future dates, and doing a click and drag when I have updates time sheets. It works, but I'd rather have it be a fully dynamic sheet. Any ideas? Thanks!
-Chris (Virginia, USA)
I'm using your template for graphing the burn down chart. My actual hours are dynamic -- (3rd column) a SUM function based on individual timesheet in the same file. I was able to use a function to make sure that any cells with a "0" value are 'blank' and not '0'. However, even with the empty cells in the 3rd column, my entire 5th column for "balance Actual" still populates all cells. The issue here is that the graph line for 'balance actual' is fully built out -- it shows as a long plateau based on the most recent calculated figure.
How do I get the balance actual to graph properly? For now, my work around is clearing out the formula from the future dates, and doing a click and drag when I have updates time sheets. It works, but I'd rather have it be a fully dynamic sheet. Any ideas? Thanks!
-Chris (Virginia, USA)
