Xa ujonga idatha kwiiSpredishithi zikaGoogle, umntu ungena engxakini yokuba \(x\) -axis ayinakho ukuzalisa ngokuzenzekelayo izithuba ezilahlekileyo kumaxabiso okubhaliweyo (njengakwiiveki zekhalenda). Ukusombulula ingxaki, uvelisa uthotho lwemihla eqhubekayo, ubale iiseli ezizenzekelayo uze ujonge iimali eziqokelelweyo.
Umzobo osemgangathweni, obala inani lamaxabiso afikayo, unezikhewu ezikhankanyiweyo (umzekelo kwiveki yekhalenda "24/2020" ayikho):
Ukuba ufuna ukuvelisa uthotho lomhla (phakathi komhla wokuqala osisigxina kunye nosuku olunxulumene nolwanamhlanje ), ukusetyenziswa kwe- ARRAYFORMULA kunye ne- ZEILE kuyacetyiswa:
9d60612e712ab8d9ea16e760161ff89b
Kuyafana nokwenziwa kwiiveki zekhalenda (kwaye, ukuba kukho imfuneko, kwiikota nakwiminyaka ngokunjalo):
9d60612e712ab8d9ea16e760161ff89b
Iseli \(F1\) umhla wokuqala kunye \(F2\) inani leentsuku ezinxulumene nomhla wanamhlanje. Ngoku sibala amaxabiso ahlukileyo kuthotho lomhla oluqhubekayo:
9d60612e712ab8d9ea16e760161ff89b
Oku kuvumela lo mzobo ungasentla ukuba uboniswe ngaphandle kwezikhewu:
