Kodi mumakonda bwanji lingaliro lowonjezera mizere yolozera motere kuchokera ku mfundo za graph pa X ndi Y axs ku ma chart anu?
Zikuwoneka zabwino, sichoncho? Kukhazikitsa izi ndikosavuta.
Tiyeni tipange tchati kaye. Sankhani mtundu womwe uli ndi gwero (mwachitsanzo, tebulo A1:B8) ndi pa tabu Ikani kusankha Madontho (mwaza) ndi magawo olumikizana pakati pa mfundo:
Tsopano tiyeni tiwonjeze zotchingira zolakwika ku mfundo zachithunzi chathu. Mu Excel 2013, izi zitha kuchitika pogwiritsa ntchito batani lolemba kumanja kwa tchati poyambitsa bokosi loyang'anira. Mipiringidzo Yolakwika:
Mu Excel 2007-2010, izi zitha kuchitika posankha pa tabu Kuyika batani Mipiringidzo Yolakwika.
Kawirikawiri, "ndevu" zooneka ngati mtanda zimagwiritsidwa ntchito kuwonetsera pa tchati zolakwika zolondola ndi zoyezera, kulolerana, makonde oscillation, ndi zina zotero. Timawagwiritsa ntchito kuti tichepetse mizere yowonetsera kuchokera ku mfundo iliyonse pa axis. Kuti muchite izi, choyamba sankhani "ndevu" zoyima ndikudina njira yachidule ya kiyibodi Ctrl + 1 kapena dinani kumanja pa iwo ndikusankha lamulo Masamba Olakwika Osasintha. Pazenera lomwe limatsegulidwa, mutha kusintha mawonekedwe awo ndi kukula kwake.
Sankhani njira Mwamakonda (Mwambo) ndi kukanikiza batani Khazikitsani Makhalidwe. Pazenera lomwe limatsegulidwa, timayika zolakwika zabwino ("ndevu" zapamwamba) = 0, ndipo monga zotsika ("ndevu" zotsika) timasankha deta yoyambirira pamodzi ndi Y, mwachitsanzo, B2: B8:
Pambuyo pang'anani OK "ndevu" zakumtunda ziyenera kutha, ndipo zapansi ziyenera kutambasulira ndendende ku X axis, kuwonetsa mizere yolozera:
Ingobwerezanso njirayi pazolakwika zopingasa chimodzimodzi, kutchula mtengo wabwino wa cholakwika =0, ndi mtengo woyipa monga mtundu A2:A8:
Maonekedwe a mizere akhoza kusinthidwa mwa kuwonekera kumanja pa iwo ndi lamulo Maonekedwe a zitsulo zoyima (zopingasa) za zolakwika (Mabala Olakwika a Format) ndi kusankha mtundu kwa iwo, mzere wa madontho m'malo mwa mzere wolimba, ndi zina zotero.
Ngati muli ndi madeti pa X axis, ndiye mutasintha kukula kwa malire olakwika opingasa, sikelo "imayenda" motsatira X axis ndipo muyenera kusintha malire ake podina kumanja pa axis ndikusankha. lamulo Mtundu olamulira kapena mwa kukanikiza njira yachidule ya kiyibodi Ctrl + 1:
- Momwe mungapangire chithunzi cha "moyo".
- Momwe mungasinthire tchati mumtundu wa ma cell okhala ndi data yochokera
- Momwe mungapangire tchati cha mathithi