is there a way of getting excel to automatically generate a line that spans from the earliest date to the latest date - (see attached)
I suspect this one might be a bridge to far
I am currently using the formula in the gannt chart area with the characters set up in the conditioning formating
=FILTER(CHAR({186,190,191,192,187}),(G$2<=$B4:$F4)*(G$2>$B4:$F4-($H$2-$G$2)),"")
however im having to put the line in manually
any ideas appreciated
Thanks
I suspect this one might be a bridge to far
I am currently using the formula in the gannt chart area with the characters set up in the conditioning formating
=FILTER(CHAR({186,190,191,192,187}),(G$2<=$B4:$F4)*(G$2>$B4:$F4-($H$2-$G$2)),"")
however im having to put the line in manually
any ideas appreciated
Thanks