Kuparadzira zano nemiseve "kwakazova"

Pakudzidziswa kwekuona nguva pfupi yadarika, mumwe wevadzidzi akataura basa rinonakidza: zvinodikanwa kuratidza shanduko mumitengo uye purofiti yezvimwe zvigadzirwa mumakore maviri apfuura. Ehe, haugone kunetseka uye kuenda nenzira yakajairwa, kudhirowa banal magirafu, makoramu kana kunyange, Mwari ndiregererei, "makeke". Asi kana iwe uchizvisundira zvishoma, ipapo mhinduro yakanaka mumamiriro ezvinhu akadaro inogona kunge iri kushandisa rudzi rwakakosha paradzira zano nemiseve ("pamberi-pamberi"):

Zvechokwadi, izvi hazvina kukodzera chete zvinhu uye mari-bhenefiti. Paunenge uchienda, iwe unogona kuuya neakawanda mamiriro apo rudzi urwu rwechati ruchave "mumusoro wenyaya", semuenzaniso:

• Shanduko yemuhoro (X) uye tarisiro yehupenyu (Y) yenyika dzakasiyana mumakore maviri apfuura.
• Shandura muhuwandu hwevatengi (X) uye avhareji cheki (Y) yemaodha eresitorendi
  
• Chiyero chekukosha kwekambani (X) uye nhamba yevashandi mairi (Y)
  
• ...
  

Kana chimwe chinhu chakafanana chikaitika mukuita kwako, saka zvine musoro kufunga kuti ungavaka sei runako rwakadaro.

Ini ndakatonyora nezve bubble machati (kunyangwe ane animated). Kuparadzira chati (XY Scatter Chart) - iyi inyaya yakakosha yebubble (Bubble Chart), asi isina yechitatu parameter - saizi yemabhuru. Avo. pfungwa imwe neimwe pagirafu inotsanangurwa nemiganhu miviri chete: X uye Y. Nokudaro, kuvaka kunotanga nekugadzirira kwekutanga data nenzira yematafura maviri:

Ngatitangei kuvaka "zvaive" kutanga. Kuti uite izvi, sarudza huwandu A3: C8 uye sarudza pane tab Insert (Isa) murayiro Machati anokurudzirwa (Machati anokurudzirwa), uye wozoenda kune tab Madhayagiramu ese (Machati ese) uye sarudza rudzi nguva (XY Scatter Chart):

Mushure mekunge mavharidza OK tinowana pasina padhayagiramu yedu.

Zvino ngatiwedzerei data kwairi kubva patafura yechipiri "Yakave". Nzira iri nyore yekuita izvi ndeyekukopa. Kuti uite izvi, sarudza iyo E3: F8, ikope uye, kana wasarudza iyo chati, ita yakakosha kunama mairi uchishandisa. Musha — Namira — Special Namira (Kumba - Namira - Namira Yakakosha):

Muhwindo rinoonekwa, sarudza akakodzera ekuisa sarudzo:

Mushure mekudzvanya pane OK, iyo yechipiri seti yemapoinzi ("iva") ichaonekwa padhizaini yedu:

Zvino chikamu chinonakidza. Kutevedzera miseve, zvichave zvakafanira kugadzirira tafura yechitatu yeinotevera fomu kubva kune data rekutanga uye rechipiri tafura:

Cherechedza kuti yakagadzirwa sei:

• mitsara kubva kumatafura ekwakabva anochinjana ari maviri maviri, kugadzirisa mavambo nemagumo emuseve wega wega
  
• mbiri imwe neimwe inoparadzaniswa kubva kune imwe nemutsara usina chinhu kuitira kuti chinobuda ive miseve yakasiyana, uye kwete imwe hombe.
• kana iyo data inogona kuchinja mune ramangwana, saka zvine musoro kushandisa kwete nhamba, asi zvinongedzo kune matafura ekutanga, kureva musero H4 pinda fomula = B4, muchitokisi H5 pinda fomu = E4, zvichingodaro.
  

Ngatisarudzei tafura yakagadzirwa, toikopa kubhodhibhodhi uye toiwedzera kudhiyagiramu yedu tichishandisa Paste Special, sezvatakaita pakutanga:

Mushure mekudzvanya OK, mapoinzi matsva ekutanga uye ekupedzisira emuseve wega wega anozoonekwa padhizaini (ini ndinazvo mugrey), inovhara iyo yakatovakwa yebhuruu neorenji. Kurudyi tinya pavari uye sarudza command Shandura rudzi rwechati kune dzakatevedzana (Shandura Series Chart Type). Muhwindo rinovhura, pamitsara yepakutanga "pamberi" uye "pamberi", siya rudzi nguva, uye nokuda kwekutevedzana kwe "miseve" yatinoisa Nongedza nemitsara yakatwasuka:

Mushure mekudzvanya OK, mapoinzi edu "aive" uye "akave" achabatanidzwa nemitsetse yakatwasuka. Chasara kudzvanya-kurudyi pavari uye wosarudza murairo Data series format (Format Data Series), wobva waisa mitsara paramita: ukobvu, rudzi rwemuseve nemasaizi awo:

Nokuda kwekujekesa, zvingava zvakanaka kuwedzera mazita ezvigadzirwa. Nokuda kweizvi:

1. Dzvanya pane chero poindi uye sarudza kubva pane yemukati menyu Wedzera zvinyorwa zve data (Wedzera Data Labels) - manhamba mapepa emazita achawedzerwa
   
2. Kurudyi tinya pane mavara uye sarudza command Siginecha Format (Format Labels)
3. Mupanera rinovhura, tarisa bhokisi Values ​​kubva kumasero (Values ​​kubva kumaseru), tinya bhatani Sarudza Range uye simbisa mazita echigadzirwa (A4: A8).