Yaya kuke son ra'ayin ƙara irin waɗannan layin tsinkaya na gani daga wuraren jadawali akan gatura X da Y zuwa wasu sigogin ku?
Yayi kyau, dama? Aiwatar da wannan abu ne mai sauqi.
Bari mu fara gina ginshiƙi. Zaɓi kewayon tare da bayanan tushen (a cikin misalinmu, tebur A1:B8) kuma akan shafin Saka zabi Dige (Watse) tare da haɗa sassan tsakanin maki:
Yanzu bari mu ƙara kuskuren sanduna zuwa wuraren zanenmu. A cikin Excel 2013, ana iya yin wannan ta amfani da maɓallin alamar da ke hannun dama na ginshiƙi ta hanyar kunna akwati. Kuskuren sanduna:
A cikin Excel 2007-2010, ana iya yin wannan ta zaɓin shafin Layout button Kuskuren sanduna.
Yawanci, ana amfani da waɗannan "whiskers" masu siffar giciye don nuna gani a kan ginshiƙi daidaitattun daidaito da kurakuran aunawa, juriya, oscillation corridors, da dai sauransu. Muna amfani da su don rage layin tsinkaya daga kowane batu akan axis. Don yin wannan, da farko zaɓi “whiskers” a tsaye kuma danna gajeriyar hanyar keyboard Ctrl + 1 ko danna dama akan su kuma zaɓi umarni Tsara Manufofin Kuskuren Tsaye. A cikin taga da ke buɗe, zaku iya canza saitunan nuni da girman su.
Zabi wani zaɓi Custom (Custom) kuma danna maɓallin Saita Darajoji. A cikin taga da ke buɗewa, mun saita ƙimar kuskure mai kyau (babban “whisker”) = 0, kuma azaman ƙimar mara kyau (ƙananan “whiskers”) muna zaɓar bayanan farko tare da axis Y, watau kewayon B2: B8:
Bayan danna kan OK "Wisker" na sama ya kamata ya ɓace, kuma ƙananan ya kamata su shimfiɗa daidai zuwa axis X, suna nuna layin tsinkaya:
Ya rage don maimaita wannan hanya don kurakurai a kwance daidai daidai da hanya ɗaya, ƙayyadadden ƙimar kuskuren = 0, da mummunan darajar kamar kewayon A2: A8:
Ana iya daidaita bayyanar layin ta danna-dama akan su tare da umarnin Tsarin sandunan kurakurai a tsaye (a kwance) (Tsarin Kuskuren Bars) da zabar musu launi, layi mai dige-dige maimakon tsayayyen layi, da dai sauransu.
Idan kuna da kwanakin akan axis X, to bayan daidaita girman iyakokin kuskuren kwance, ma'aunin zai iya "matsawa" tare da axis X kuma kuna buƙatar daidaita ƙarancin iyakar ta ta danna-dama akan axis kuma zaɓi. umarnin Tsarin Axis ko ta hanyar latsa gajeriyar hanyar madannai Ctrl + 1:
- Yadda ake gina zane mai ma'amala "rayuwa".
- Yadda ake canza launi ta atomatik a cikin launi na sel tare da bayanan tushe
- Yadda ake gina ginshiƙi na ruwa