How can I get the Gant Chart to skip over weekends and holidays all together?
@flashtheoriginal
3 жыл бұрын
Hi. How can you re-arrange to get each week (Monday as the signal point) along the top, rather than each individual day?
@daveh4208
2 жыл бұрын
I really liked what you did to show the weekends and holidays, but I was wondering if you could make a video to explain one more thing. If I'm working at a company that only works Monday - Friday, and takes off the federal holiday, how can I get the bars to change? For example, on row 20, task 5. the duration of the task is 24 workdays but there are 8 weekend days in the time period that employees won't be working. How do we get the bar to only count workdays and exclude weekends and holidays?
@2nd-qh
Жыл бұрын
Thank you
@shilpanathwani7642
3 жыл бұрын
Hi - can you tell me how to hide weekends rather than having them highlighted in a different colour?
@codymathews2601
4 жыл бұрын
Great explanations!
@dragonknight92
3 жыл бұрын
Had an issue with the text for months as it was showing "00" when starting up a new file. Incase anybody has the same issue go to "find & select --> Replace" change "mmmm" to "MMMM". Hope this saves somebody some time
@theresaabdulmalik2356
4 жыл бұрын
Hello, Please how do I customize the legend? Change colour and text and have it reflect in the category section and highlight in your new selected colour on the date? Thank
@anshikarimal5808
3 жыл бұрын
Did you figure out how to do this?
@willjack7597
3 жыл бұрын
I'm trying to do this but my pop up screen tells me I need an apostrophe in front of the equals to S formula?? My formula reads - =I$7='S' like yours but doesn't allow formatting???
@skyhigh450
3 жыл бұрын
I'm not able to do it as well.. can anyone please specify formula.. I have it as =$I$7='S'
@tvstx82996
3 жыл бұрын
Use double quotes around it =I$7="S"
@robertsalazar2866
4 жыл бұрын
How do you remove weekends and include only work days (mon-fri)?
Пікірлер: 15