Watsa shiri tare da kibiyoyi "an zama"

A wani horo kan hangen nesa kwanan nan, ɗaya daga cikin ɗaliban ya bayyana wani aiki mai ban sha'awa: wajibi ne a gani a nuna canje-canjen farashin da ribar ga wasu samfuran a cikin shekaru biyu da suka gabata. Tabbas, ba za ku iya damuwa ba kuma ku tafi hanyar da aka saba, zana banal jadawali, ginshiƙai ko ma, Allah gafarta mani, "cakes". Amma idan kun tura kanku kadan, to, mafita mai kyau a cikin irin wannan yanayin na iya zama don amfani da nau'i na musamman warwatsa makirci tare da kibiyoyi ("kafin-kafin"):

Tabbas, wannan ba kawai ya dace da kaya da fa'idar farashi ba. A kan tafiya, zaku iya fito da yanayi da yawa inda wannan nau'in ginshiƙi zai kasance "a cikin batun", misali:

• Canjin kudin shiga (X) da tsawon rai (Y) na ƙasashe daban-daban a cikin shekaru biyu da suka gabata.
• Canji a cikin adadin abokan ciniki (X) da matsakaicin rajistan (Y) na odar gidan abinci
  
• Rabon darajar kamfani (X) da adadin ma'aikatan da ke cikinsa (Y)
  
• ...
  

Idan wani abu makamancin haka ya faru a cikin aikin ku, to yana da ma'ana don gano yadda ake gina irin wannan kyawun.

Na riga na rubuta game da ginshiƙan kumfa (har ma da masu rai). Watsawa ginshiƙi (XY Scatter Chart) - wannan lamari ne na musamman na kumfa (Bubble Chart), amma ba tare da siga na uku ba - girman kumfa. Wadancan. Kowane batu a kan jadawali an kwatanta shi da sigogi biyu kawai: X da Y. Don haka, ginin yana farawa tare da shirye-shiryen bayanan farko a cikin nau'i na tebur guda biyu:

Bari mu fara gina abin da “ya kasance” da farko. Don yin wannan, zaɓi kewayon A3:C8 kuma zaɓi kan shafin Saka (Saka) umurnin Shafukan da aka ba da shawarar (Shawarwarin Charts), sannan ka tafi shafin Duk zane-zane (Dukkan jadawali) kuma zaɓi nau'in Point (XY Scatter Chart):

Bayan danna kan OK mun sami komai na zanenmu.

Yanzu bari mu ƙara bayanai zuwa gare shi daga tebur na biyu "Ya zama". Hanya mafi sauƙi don yin wannan ita ce ta yin kwafi. Don yin wannan, zaɓi kewayon E3:F8, kwafa shi kuma, bayan zaɓar ginshiƙi, yi manna na musamman a ciki ta amfani da Gida - Manna - Manna na Musamman (Gida - Manna - Manna na Musamman):

A cikin taga da ya bayyana, zaɓi zaɓuɓɓukan saka da suka dace:

Bayan danna Ok, saitin maki na biyu (“zama”) zai bayyana akan zanenmu:

Yanzu bangaren fun. Don yin kwatankwacin kibiyoyi, zai zama dole a shirya tebur na uku na nau'i mai zuwa daga bayanan tebur na farko da na biyu:

Lura yadda aka saita shi:

• layuka daga teburin tushen suna musanya bi-biyu, suna gyara farkon da ƙarshen kowace kibiya
  
• kowane nau'i-nau'i an raba su da sauran ta hanyar layi mara kyau don abin da ake fitarwa ya zama kiban daban, kuma ba babba ɗaya ba.
• idan bayanan na iya canzawa a nan gaba, to yana da ma'ana don amfani da ba lambobi ba, amma haɗin kai zuwa tebur na asali, watau a cikin tantanin halitta H4 shigar da dabara = B4, a cikin tantanin halitta H5 shigar da dabara = E4, da sauransu.
  

Bari mu zaɓi tebur ɗin da aka ƙirƙira, mu kwafa shi zuwa allon allo sannan mu ƙara shi cikin zanenmu ta amfani da Manna Special, kamar yadda muka yi a baya:

Bayan danna Ok, sabbin maki farawa da ƙarshen kowane kibiya zasu bayyana akan zane (Ina da su cikin launin toka), wanda ke rufe waɗanda aka riga aka gina shuɗi da lemu. Dama danna su kuma zaɓi umarni Canja nau'in ginshiƙi don jerin abubuwa (Canja Nau'in Chart). A cikin taga wanda ya buɗe, don ainihin layuka "kafin" da "kafin", bar nau'in Point, kuma don jerin "kibau" mun saita Nuna tare da madaidaiciyar layi:

Bayan danna Ok, za a haɗa maki "ya" da "sun kasance" ta hanyar layi madaidaiciya. Duk abin da ya rage shine danna-dama akan su kuma zaɓi umarnin Tsarin bayanai (Format Data Series), sannan saita sigogin layi: kauri, nau'in kibiya da girmansu:

Don bayyanawa, zai yi kyau a ƙara sunayen kayan. Don wannan:

1. Danna kowane batu kuma zaɓi daga menu na mahallin Ƙara alamun bayanai (Ƙara Takaddun Bayanai) – Za a ƙara alamun lamba
   
2. Dama danna kan lakabin kuma zaɓi umarni Tsarin Sa hannu (Tsarin Lambobin)
3. A cikin kwamitin da ya buɗe, duba akwatin Dabi'u daga sel (Dabi'u daga sel), danna maballin Zaɓi Range da haskaka sunayen samfurin (A4: A8).