Forum Discussion
Gnatt chart template formula
=IFERROR(IF(LEN([@Tasks])=0,0,IF(AND('Chart Data'!$H6<=$B$12,'Chart Data'!$I6>=$B$12),ABS(OFFSET('Chart Data'!$H6,@ScrollingIncrement[scroll increment],0,1,1)-$B$12)+1,OFFSET('Chart Data'!$K6,@Scroll...
HansVogelaar this is the data it is pulling from. The 2nd row is where the error is happening from the hidden data sheet.
I see. It has something to do with the scrolling offset in B8 and the charting range in B11:B12, but I cannot discover the logic behind it. The person who designed the template appears to have intended the chart to display a date range of 16 days, but flunked it. I wouldn't rely on this template.