Duban sabon ginshiƙi da aka ƙirƙira a cikin Excel, ba koyaushe ba ne mai sauƙin fahimtar yanayin bayanan nan da nan. Wasu ginshiƙi sun ƙunshi dubban maki bayanai. Wani lokaci za ku iya faɗi da ido ko wane shugabanci bayanan ke canzawa akan lokaci, wani lokacin kuma kuna buƙatar amfani da wasu kayan aikin Excel don tantance abin da ke faruwa. Ana iya yin wannan ta amfani da layi mai tasowa da matsakaicin layi mai motsi. Mafi sau da yawa, domin sanin ko wane alkiblar bayanai ke tasowa, ana amfani da layin da ake yi a cikin ginshiƙi. Don lissafta irin wannan layi ta atomatik kuma ƙara shi zuwa ginshiƙi na Excel, kuna buƙatar ɗaukar matakai masu zuwa:
- A cikin Excel 2013, danna ko'ina a cikin ginshiƙi sannan danna alamar alamar da (+) kusa da zane don buɗe menu Abubuwan da aka tsara (Abubuwan da aka tsara). Wani zaɓi: danna maɓallin Ƙara Ƙimar Chart (Ƙara Abubuwan Shafuka), wanda ke cikin sashin Shirye-shiryen jadawali (Tsarin Tsare-tsaren) tab Constructor (Zane).
- Duba akwatin Layin Trend (Trendline).
- Don saita nau'in layin Trend, danna kibiya mai nuni zuwa dama kuma zaɓi ɗaya daga cikin zaɓuɓɓukan (madaidaici, juzu'i, hasashen layi, matsakaicin motsi, da sauransu).
Mafi yawan amfani da su shine yanayin layi na yau da kullun da matsakaicin matsakaicin motsi. Hanyar layi - wannan shi ne madaidaiciyar layi wanda ke cikin hanyar da nisa daga gare ta zuwa kowane maki a kan jadawali kadan ne. Wannan layin yana da amfani lokacin da aka sami tabbacin cewa bayanan da ke gaba zasu bi wannan tsari.
Very taimako motsi matsakaicin layi a wurare da dama. Irin wannan layi, ba kamar yanayin layi ba, yana nuna matsakaicin matsakaici don adadin maki akan ginshiƙi, wanda za'a iya canzawa. Ana amfani da matsakaicin layi mai motsi lokacin da dabarar ke ba da bayanai don ƙirƙira ta canza akan lokaci kuma ana buƙatar ƙirƙira yanayin akan ƴan maki da suka gabata kawai. Don zana irin wannan layin, bi matakai na 1 da 2 daga sama, sannan yi haka:
- Danna kibiya dama a jere Layin Trend (Trendline) kuma zaɓi zaɓi motsi matsakaici (Matsakaicin motsi).
- Yi matakai 1 da 2 daga misalin da ya gabata kuma latsa Ƙarin zaɓuɓɓuka (Ƙarin zaɓuɓɓuka).
- A cikin bude panel Tsarin Trendline (Format Trendline) a tabbata an duba akwati Arirgar tacewa (Matsakaicin Motsawa).
- Zuwa dama na siga Arirgar tacewa (Matsakaicin Motsawa) shine filin points (Lokaci). Wannan yana saita adadin maki da za a yi amfani da su don ƙididdige matsakaicin ƙima don ƙirƙira layin da aka yi. Saita adadin maki, wanda, a ra'ayin ku, zai zama mafi kyau. Misali, idan kuna tunanin cewa wani yanayi a cikin bayanan bai canza ba kawai don maki 4 na ƙarshe, sannan shigar da lamba 4 a cikin wannan filin.
Trendlines a cikin Excel babbar hanya ce don samun ƙarin bayani game da saitin bayanai da kuke da shi da kuma yadda yake canzawa akan lokaci. Juyin layi da matsakaicin motsi nau'ikan layi ne guda biyu waɗanda suka fi kowa kuma masu amfani ga kasuwanci.