Uchungechunge lwedethi ku-Google AmaSpredishithi

Lapho ubuka idatha ku-Google AmaSpredishithi, umuntu uhlangabezana nenkinga yokuthi i - \(x\) -axis ayikwazi ukugcwalisa ngokuzenzakalelayo izikhala ezingekho kumanani wombhalo (njengasemavikini ekhalenda). Ukuxazulula inkinga, ukhiqiza uchungechunge oluqhubekayo lwezinsuku, ubale amaseli azivelela bese ubona ngeso lengqondo izibalo eziqoqiwe.


Umdwebo ojwayelekile, obala inani lamanani avela, unezikhala ezishiwo (ngokwesibonelo iviki lekhalenda "24/2020" alikho):

Uma ufuna ukukhiqiza uchungechunge lwedethi (phakathi kwedethi yokuqala engaguquki nosuku oluhlobene nanamuhla), kunconywa ukusetshenziswa kwe- ARRAYFORMULA ne- ZEILE:

9d60612e712ab8d9ea16e760161ff89b

Okufanayo kungenziwa kumaviki ekhalenda (futhi, uma kunesidingo, kwezindawo zokuhlala kanye neminyaka futhi):

9d60612e712ab8d9ea16e760161ff89b

Iseli \(F1\) idethi yokuqala kanye \(F2\) nenombolo yezinsuku ezihlobene nanamuhla. Manje sibala amanani ahlukile ochungechunge lwedethi oluqhubekayo:

9d60612e712ab8d9ea16e760161ff89b

Lokhu kuvumela umdwebo ongenhla ukuthi uboniswe ngaphandle kwezikhala:

Emuva