Kwenzekeni kuWizadi Yeshadi ku-Excel?

Iseluleki Seshadi ikhishwe ku-Excel 2007 futhi ayizange ibuyiselwe ezinguqulweni zakamuva. Eqinisweni, lonke uhlelo lokusebenza ngemidwebo lwashintshwa, futhi abathuthukisi abazange bakubone kudingekile ukwenza iwizadi yomdwebo ibe yesimanje namathuluzi ahlobene.

Kumele ngisho ukuthi uhlelo olusha lokusebenza ngamashadi luhlanganiswe ngokujulile kusixhumi esibonakalayo esisha se-Menu Ribbon futhi kulula kakhulu ukusebenza ngalo kunewizadi eyandulelayo. Ukusetha kunengqondo futhi kuzo zonke izinyathelo ungabona ukubuka kuqala komdwebo wakho ngaphambi kokwenza izinguquko.

Ukuqhathaniswa "kweWizadi Yeshadi" namathuluzi esimanje

Kulabo abajwayele iwizadi yeshadi, sifuna ukusho ukuthi uma usebenza ne-Ribbon, wonke amathuluzi afanayo ayatholakala, ngokuvamile ngokuchofoza okumbalwa kwegundane.

Ezinguqulweni ezindala ze-Excel, ngemva kokuchofoza imenyu Faka (Faka) > Umdwebo (Ishadi) wizadi ibonise amabhokisi ezingxoxo amane ngokulandelana:

  1. Uhlobo lweshadi. Ngaphambi kokukhetha idatha yeshadi, udinga ukukhetha uhlobo lwayo.
  2. Umthombo wedatha yeshadi. Khetha amaseli aqukethe idatha ukuze ahlele ishadi futhi ucacise imigqa noma amakholomu okufanele aboniswe njengochungechunge lwedatha eshadini.
  3. Izinketho zeshadi. Enza ngendlela oyifisayo ukufometha nezinye izinketho zeshadi njengamalebula edatha nezimbazo.
  4. Ukubekwa imidwebo. Khetha ishidi elikhona noma dala ishidi elisha ukuze usongethe ishadi olidalayo.

Uma udinga ukwenza izinguquko kumdwebo osuvele udaliwe (ungaba kanjani ngaphandle kwawo?!), ungaphinda usebenzise iwizadi yomdwebo noma, kwezinye izimo, imenyu yokuqukethwe noma imenyu. Framework (Ifomethi). Kusukela nge-Excel 2007, inqubo yokudala amashadi yenziwe lula kangangokuthi i-Chart Wizard ayisadingeki.

  1. Gqamisa idatha. Ngenxa yokuthi ekuqaleni kunqunywa ukuthi iyiphi idatha ezosetshenziselwa ukwakha igrafu, kungenzeka ukubuka kuqala umdwebo ohlelweni lokuwudala.
  2. Khetha uhlobo lweshadi. Kuthebhu ethuthukisiwe Faka (Faka) khetha uhlobo lweshadi. Uhlu lwama-subtypes luzovuleka. Ngokuhambisa igundane phezu kwazo zonke, ungabuka kuqala ukuthi igrafu izobukeka kanjani ngokusekelwe kudatha ekhethiwe. Chofoza ohlotsheni oluncane olukhethiwe futhi i-Excel izokwakha ishadi ekhasini lokusebenza.
  3. Yenza umklamo nesakhiwo ngendlela oyifisayo. Chofoza eshadini elidaliwe - kulokhu (kuye ngokuthi inguqulo ye-Excel) kuzovela amathebhu amabili noma amathathu engeziwe ku-Ribbon. Amathebhu umakhi (Idizayini), Framework (Ifomethi) nakwezinye izinguqulo Isakhiwo (Isakhiwo) sikuvumela ukuthi usebenzise izitayela ezihlukahlukene ezidalwe ochwepheshe kumdwebo owenziwe, ngokuchofoza nje isithonjana esihambisanayo ku-Ribbon.
  4. Enza ngendlela oyifisayo ama-elementiamagremu. Ukuze ufinyelele amapharamitha wesici seshadi (isibonelo, imingcele ye-eksisi), vele uchofoze kwesokudla entweni bese ukhetha umyalo owufunayo kumenyu yokuqukethwe.

Isibonelo: Ukudala i-histogram

Sakha itafula eshidini elinedatha, isibonelo, ekuthengisweni emadolobheni ahlukahlukene:

Ku-Excel 1997-2003

Chofoza kwimenyu Faka (Faka) > Umdwebo (Ishadi). Kuwindi lewizadi elivelayo, yenza lokhu okulandelayo:

  1. Uhlobo lweshadi (Uhlobo Lweshadi). Chofoza ishadi lebha (Ikholomu) bese ukhetha eyokuqala yezinhlobo ezincane ezihlongozwayo.
  2. Umthombo yeboidatha amashadi (Idatha Yomthombo Weshadi). Faka okulandelayo:
    • Ibanga (Ibanga ledatha): faka B4:C9 (kugqanyiswe ngombala oluhlaza okwesibhakabhaka ophaphathekile esithombeni);
    • Imigqa phakathi (Uchungechunge): khetha amakholomu (amakholomu);
    • Kuthebhu ethuthukisiwe Umugqa (Uchungechunge) ensimini Amasignesha e-eksisi engu-X (Amalebula esigaba) cacisa ububanzi A4:A9.
  3. Izinketho Zeshadi (Izinketho Zeshadi). Engeza isihloko esithi “Ukuthengiswa kwe-Metropolitan Area»kanye nenganekwane.
  4. Ukubekwa kweshadi (Indawo Yeshadi). Hlola inketho Beka ishadi eshidini > kuyatholakala (Njengento ku) bese ukhetha Ishidi1 (Ishidi1).

Ku-Excel 2007-2013

  1. Khetha ibanga lamaseli ngegundane B4:C9 (kugqanyiswe ngokuluhlaza okwesibhakabhaka okukhanyayo esithombeni).
  2. Kuthebhu ethuthukisiwe Faka (Faka) chofoza Faka i-histogram (Faka Ishadi Lekholomu).
  3. Khetha I-Histogram eneqoqo (Ikholomu Ehlanganisiwe engu-2-D).
  4. Eqenjini lethebhu elivela kuribhoni Ukusebenza namashadi (Amathuluzi Eshadi) vula ithebhu umakhi (Design) bese ucindezela Khetha idatha (Khetha Idatha). Ebhokisini lengxoxo elivelayo:
    • In the Amalebula e-eksisi avundlile (izigaba) (Amalebula Avundlile (esigaba)) chofoza Guqula (Hlela) kuvuliwe A4:A9bese ucindezela OK;
    • Guqula Umugqa wesi-1 (Uchungechunge1): ensimini Igama lomugqa (Igama lochungechunge) khetha iseli B3;
    • Guqula Umugqa wesi-2 (Uchungechunge2): ensimini Igama lomugqa (Igama lochungechunge) khetha iseli C3.
  5. Eshadini elidaliwe, kuye ngenguqulo ye-Excel, chofoza kabili esihlokweni seshadi, noma uvule ithebhu Ukusebenza namashadi (Amathuluzi Eshadi) > Isakhiwo (Isakhiwo) bese ufaka “Ukuthengiswa kwe-Metropolitan Area".

Okufanele ngikwenze?

Zinike isikhathi sokuhlola izinketho zeshadi ezitholakalayo. Bona ukuthi yimaphi amathuluzi kumathebhu weqembu Ukusebenza namashadi (Amathuluzi e-Chart). Iningi lazo liyazichaza noma lizokhombisa ukubuka kuqala ngaphambi kokuthi kukhethwe.

Kakade, ingabe ikhona indlela engcono yokufunda kunokuprakthiza?

shiya impendulo