LibreOffice Calc - Gantt Chart Part 2

[@IntelligenceEra]

A tutorial using that actual bar chart would be nice

[@tanmaykumar9277]

Can I set milestones in this method?

[@sunkaushik5404]

Thanks, both parts to this video are very helpful!

[@Panopia_Tutorials]

+Sun Kaushik I'm very glad to hear it, I will be doing more on Gantt charts soon.

[@hiswinnie]

Other than the "W" Workdays are green and "H" Holidays are blue, now there's another category named "working holidays", is there another way to program "WH" into the chart and make it yellow? I get a sense you already have similar teaching in the pool, how to search for it? If not, any hint? Thank you for your excellent videos.

[@Fjuron]

The coding stuff doesn't work for me. It gives me error 501 and nothing happens when i press Shift+F4

[@gofundake4644]

Go to "Tools"=>"Customize"=>in "Category" choose "Insert"=> in "Function" choose "Cycle Cell Reference Types" then click on "Shortcut Key" area and press the shortcut key you like (for example "F3"), then click on "Modify". Now "F3" should anchor rows and columns or both. "The coding stuff" does work, you probably just forgot to put absolute references in the right places or messed up the parentheses. This is the formula:=IF(AND(E$7>=$B8,E$7

[@robertthompsonii3301]

Try just F4 (without holding shift)