Uwuthanda kanjani umqondo wokwengeza imigqa yokuqagela ebonakalayo ukusuka emaphuzwini egrafu kuzimbazo zika-X kanye no-Y kwamanye amashadi akho?
Kubukeka kukuhle, akunjalo? Ukwenza lokhu kulula kakhulu.
Ake sakhe ishadi kuqala. Khetha ububanzi obunedatha yomthombo (esibonelweni sethu, ithebula A1:B8) nakuthebhu Faka khetha Ichashazi (Scatter) namasegimenti axhumayo phakathi kwamaphoyinti:
Manje ake sengeze imigoqo yamaphutha kumaphuzu omdwebo wethu. Ku-Excel 2013, lokhu kungenziwa kusetshenziswa inkinobho yophawu lokuhlanganisa kwesokudla seshadi ngokunika amandla ibhokisi lokuhlola Amaphutha Amabha:
Ku-Excel 2007-2010, lokhu kungenziwa ngokukhetha kuthebhu Isakhiwo inkinobho Amaphutha Amabha.
Ngokuvamile, lezi "ntshebe" ezimise okwesiphambano zisetshenziselwa ukubonisa ngokubukeka eshadini ukunemba namaphutha okulinganisa, ukubekezelelana, amaphasishi e-oscillation, njll. Siwasebenzisela ukwehlisa imigqa yokuqagela ukusuka endaweni ngayinye ku-eksisi. Ukuze wenze lokhu, khetha kuqala "izintshebe" eziqondile bese ucindezela isinqamuleli sekhibhodi Ctrl + 1 noma chofoza kwesokudla kuzo bese ukhetha umyalo Fometha Amabha Ephutha Amile. Ewindini elivulayo, ungashintsha izilungiselelo zabo zokubonisa nosayizi.
Khetha okukhethwa kukho Ngokwezifiso (Custom) bese ucindezela inkinobho Setha Amagugu. Efasiteleni elivulayo, sibeka inani lephutha eliphozithivu ("whisker") = 0, futhi njengamanani angalungile ("amadevu" aphansi) sikhetha idatha yokuqala ku-axis Y, okungukuthi ububanzi B2: B8:
Ngemuva kokuchofoza OK "Amadevu" aphezulu kufanele anyamalale, futhi aphansi kufanele alule ngqo ku-axis X, ekhombisa imigqa yokuqagela:
Kusele ukuphinda le nqubo kumaphutha avundlile ngendlela efanayo ncamashi, kucaciswe inani eliphozithivu lephutha =0, kanye nevelu elinegethivu njengobubanzi A2:A8:
Ukubukeka kwemigqa kungalungiswa ngokuchofoza kwesokudla kuyo ngomyalo Ifomethi yamabha wamaphutha aqondile (avundlile) (Amabha Ephutha Yefomethi) nokukhetha umbala wabo, umugqa onamachashazi esikhundleni somugqa oqinile, njll.
Uma unezinsuku ku-X eksisi, khona-ke ngemva kokulungisa usayizi wemikhawulo yephutha evundlile, isikali cishe sizo "hamba" eduze ne-X futhi uzodinga ukulungisa umkhawulo waso omncane ngokuchofoza kwesokudla ku-eksisi bese ukhetha. umyalo Fometha i-eksisi noma ngokucindezela isinqamuleli sekhibhodi Ctrl + 1:
- Ungawakha kanjani umdwebo "bukhoma" osebenzisanayo
- Ungafaka kanjani umbala eshadini ngokuzenzakalelayo kumbala wamaseli anedatha yomthombo
- Indlela yokwakha ishadi lempophoma