Chiwembu chomwaza ndi mivi “chinakhala”

Pamaphunziro owonera posachedwa, m'modzi mwa ophunzirawo adalankhula ntchito yosangalatsa: ndikofunikira kuwonetsa kusintha kwamitengo ndi phindu lazinthu zina zaka ziwiri zapitazi. Zachidziwikire, simungathe kupsinjika ndikuyenda momwemo, kujambula ma graph a banal, mizati kapena ngakhale, Mulungu andikhululukire, "mikate". Koma ngati mumadzikakamiza pang'ono, ndiye kuti njira yabwino yothetsera vutoli ingakhale kugwiritsa ntchito mtundu wapadera kuwaza chiwembu ndi mivi (“patsogolo”):

Inde, izi sizili zoyenera kwa katundu ndi mtengo-phindu. Popita, mutha kubwera ndi zochitika zambiri zomwe mtundu uwu wa tchati udzakhala "pamutu", mwachitsanzo:

• Kusintha kwa ndalama (X) ndi kutalika kwa moyo (Y) kwa mayiko osiyanasiyana pazaka ziwiri zapitazi.
• Kusintha kwa chiwerengero cha makasitomala (X) ndi cheke chapakati (Y) cha maoda a malo odyera
  
• Chiŵerengero cha mtengo wa kampani (X) ndi chiwerengero cha antchito mmenemo (Y)
  
• ...
  

Ngati zofananazo zikuchitika muzochita zanu, ndiye kuti ndizomveka kulingalira momwe mungapangire kukongola kotere.

Ndalemba kale za ma chart a buluu (ngakhale makanema ojambula). tchati chomwaza (XY Scatter Chart) - iyi ndi nkhani yapadera ya kuwira (Bubble Tchati), koma popanda gawo lachitatu - kukula kwa thovu. Iwo. mfundo iliyonse pa graph ikufotokozedwa ndi magawo awiri okha: X ndi Y. Choncho, kumangako kumayamba ndi kukonzekera deta yoyamba mu mawonekedwe a matebulo awiri:

Tiyeni timange chimene “chinali” poyamba. Kuti muchite izi, sankhani mtundu wa A3:C8 ndikusankha pa tabu Ikani (Ikani) lamulo Ma chart ovomerezeka (Matchati ovomerezeka), ndiyeno pitani ku tabu Zithunzi zonse (Ma chart onse) ndi kusankha mtundu Point (XY Scatter Chart):

Pambuyo pang'anani OK timapeza chopanda kanthu cha chithunzi chathu.

Tsopano tiyeni tiwonjezere deta kwa izo kuchokera pa tebulo lachiwiri "Anakhala". Njira yosavuta yochitira izi ndi kukopera. Kuti muchite izi, sankhani mtundu E3:F8, koperani ndipo, mutasankha tchati, pangani phala lapadera momwemo. Kunyumba - Matani - Matigari apadera (Kunyumba - Matani - Matani Chapadera):

Pazenera lomwe likuwoneka, sankhani zosankha zoyenera kuyika:

Mukadina Chabwino, gawo lachiwiri la mfundo ("khalani") liwonekera pazithunzi zathu:

Tsopano gawo losangalatsa. Kuti muyese mivi, padzakhala kofunikira kukonzekera tebulo lachitatu la mawonekedwe otsatirawa kuchokera pazambiri za tebulo loyamba ndi lachiwiri:

Onani momwe idakhazikitsira:

• mizere yochokera ku magwero a tebulo imasinthana pawiri, kukonza chiyambi ndi mapeto a muvi uliwonse
  
• gulu lirilonse limalekanitsidwa ndi ena ndi mzere wopanda kanthu kotero kuti zotuluka zake ndi mivi yosiyana, osati imodzi yayikulu.
• ngati deta ingasinthe m'tsogolomu, ndiye kuti n'zomveka kugwiritsa ntchito osati manambala, koma kugwirizana kwa matebulo oyambirira, mwachitsanzo mu selo H4 lowetsani chilinganizo = B4, mu selo H5 lowetsani chilinganizo = E4, ndi zina zotero.
  

Tiyeni tisankhe tebulo lomwe lapangidwa, tiyikopere pa clipboard ndikuwonjezera pazithunzi zathu pogwiritsa ntchito Paste Special, monga tidachitira kale:

Mukadina OK, zoyambira zatsopano ndi zomaliza za muvi uliwonse zidzawonekera pazithunzi (ndili nazo mu imvi), ndikuphimba zomwe zidamangidwa kale zabuluu ndi lalanje. Dinani kumanja pa iwo ndikusankha lamulo Sinthani mtundu wa tchati kukhala mndandanda (Sintha Mtundu wa Chart Series). Pazenera lomwe limatsegulidwa, pamizere yoyambirira "patsogolo" ndi "pambuyo", siyani mtunduwo Point, ndi mndandanda wa "mivi" timayika Lozani ndi mizere yowongoka:

Pambuyo podina OK, mfundo zathu "zinali" ndi "zinakhala" zidzalumikizidwa ndi mizere yowongoka. Chotsalira ndikudina kumanja pa iwo ndikusankha lamulo Mawonekedwe a mndandanda wa data (Format Data Series), ndiyeno ikani magawo a mzere: makulidwe, mtundu wa mivi ndi makulidwe ake:

Kuti zimveke bwino, zingakhale bwino kuwonjezera mayina a katundu. Za ichi:

1. Dinani pa mfundo iliyonse ndikusankha kuchokera ku menyu yankhani Onjezani zolemba za data (Onjezani Zolemba Za data) - zilembo za manambala zidzawonjezedwa
   
2. Dinani kumanja pazolemba ndikusankha lamulo Siginecha Format (Zolemba Zamtundu)
3. Pagawo lomwe likutsegulidwa, chongani bokosilo Makhalidwe ochokera ku ma cell (Makhalidwe ochokera ku ma cell), dinani batani Sankhani Mtundu ndikuwonetsa mayina azinthu (A4: A8).