Ungawengeza kanjani igama lomdwebo ku-Excel

Anonim

Ungawengeza kanjani igama lomdwebo ku-Excel

Indlela 1: Ukuhlela ngokuzenzakalela kufakwe ibhlokhi

Indlela yokuqala ilula, ngoba isuselwa ekuhleleni igama lomdwebo ongezwe ngokuzenzakalela. Kuvela ngokushesha ngemuva kokudala amagrafu athile noma ezinye izinhlobo zezakhiwo, futhi kuzodingeka ukwenza ukuhlelwa okuningana kushintshe.

  1. Ngemuva kokudala umdwebo, chofoza umugqa we- "DIAGRAM isihloko".
  2. Ukukhetha igama leshadi elijwayelekile ngokuhlela kwalo okuqhubekayo ku-Excel

    Uma ngemuva kokudala umdwebo, igama laso azange lifakwe ngokuzenzakalelayo noma wasuswa ngengozi, sebenzisa izindlela ezilandelayo lapho kutholakala ezinye izindlela lapho kudalulwa ngokuningiliziwe.

    Indlela 2: Ithuluzi "Faka Ishadi element"

    Abasebenzisi abaningi lapho besebenza nge-Excel babhekene nethuluzi le- "Designer", elenzelwe ukuhlela imidwebo nezinye izinto zokufaka. Ingasetjenziswa ngokungeza igama ngokungaphansi komzuzu.

    1. Okokuqala, qokomisa ukuklama uqobo ukuze amathebhu abhekele ukuphatha avele ngaphezulu kwenhla.
    2. Khetha ishadi lokungeza igama nge-somevathi

    3. Hambisa kuthebhu yomklami.
    4. Shintshela kuthebhu yoConstroctor ukwengeza igama leshadi ku-Excel

    5. Ngakwesobunxele yi- "DAIRAM Lameoutes" Block, lapho udinga khona ukufaka imenyu eyehlayo ethi "Faka Ishadi eled".
    6. Ukuvula imenyu ngezinto ezishadi ukwengeza igama laso ukuze udlule

    7. Hambisa isikhombisi ku "Diagram isihloko" bese ukhetha okukodwa kokubhekisisa.
    8. Ukungeza igama lomdwebo nge-Construmer ku-Excel

    9. Manje ubona igama elijwayelekile lokubonisa futhi ungalihlela ngokushintsha hhayi okubhaliwe kuphela, kodwa futhi nefomethi yokuboniswa kwayo.
    10. Ukuhlela Igama Lomdwebo Ngemuva kokuthi Kungezwe Ngomklami ku-Excel

    Indlela efanayo iyasebenza futhi ngegama lama-axes, kuphela kumenyu eyehlayo efanayo okufanele ukhethe enye into, ukuhlela okunye kwenziwa ngendlela efanayo.

    Indlela 3: Igama elizenzakalelayo

    Inketho iwusizo ikakhulukazi kubasebenzisi abasebenza namatafula lapho igama lomdwebo liboshelwe egameni lekholomu ethile noma intambo ethile eshintsha. Kulokhu, usebenzisa ukusebenza okwakhelwe ngaphakathi, ungakha igama lomdwebo ezenzakalelayo olunikezwe iseli nokushintsha ngokuya ngokuhlelwa kwalo.

    1. Uma igama le-DIAGRAM alikho nhlobo, sebenzisa inketho yangaphambili ukuyenza.
    2. Ukwakha igama leshadi ngaphambi kokuba ezenzakalelayo ku-Excel

    3. Ngemuva kwalokho, qokomisa ukuhlela, kepha ungafaneleki lutho.
    4. Khetha igama leshadi ukuze ululaze ku-Excel

    5. Emgqeni wokufaka ifomula, bhala uphawu =, okuzosho ukuqala kwegama elizenzakalelayo.
    6. Ukufaka ukufaka intambo yefomula ukuze ushintshe ishadi le-Excel

    7. Ihlala kuphela ukuze uchofoze kuseli, igama lapho ofuna ukubela khona umdwebo uqobo. Emugqeni wokufaka wefomula, ushintsho luzovela ngokushesha - Cindezela inkinobho ethi Enter ukuyisebenzisa.
    8. Ukukhetha amaseli okushintsha igama leshadi ku-Excel

    9. Bheka ukuthi igama le-DIAGRAM lishintsha kanjani ngamandla, lihlela leli cell.
    10. Ukucushwa ngempumelelo kwegama legama leshadi ku-Excel

    Kubalulekile ukubhala isibonakaliso = ngentambo ukuhlela amafomula, futhi hhayi ukuvimba igama leshadi, ngoba i-syntax yohlelo ayisebenzi kalula futhi i-automation ngeke isebenze.

Funda kabanzi