Shaxda heerkulbeegga ee Excel

Tusaalahan, waxaan ku tusi doonaa sida loo sameeyo jaantuska heerkulbeegga gudaha Excel. Jaantuska heerkulbeegga ayaa muujinaya heerka gaaritaanka yoolka.

Si aad u abuurto jaantus heerkulbeeg ah, raac tillaabooyinkan:

  1. Muuji unug B16 (unuggani waa inuusan taaban unugyada kale ee xogta ku jira).
  2. On the Advanced tab insert ( Geli ) dhagsii badhanka Geli histogram (Column) oo dooro Histogram oo leh kooxaysi (Tiirka Isku dhafan).

Shaxda heerkulbeegga ee Excel

Natiijo:

Shaxda heerkulbeegga ee Excel

Marka xigta, deji jaantuska la sameeyay:

  1. Guji Halyeyga ku yaal dhanka midig ee jaantuska oo taabo furaha kiiboodhka delete.
  2. Beddel balaca shaxda
  3. Midig ku dhufo tiirka jaantuska, menu-ka macnaha guud dooro Qaabka taxanaha xogta (Format Xogta Taxanaha) iyo for parameter Nadiifinta dhinaca (Balladhka Farqiga) oo lagu dhigay 0%.
  4. Midig ku dhufo miisaanka boqolleyda ee jaantuska, menu-ka macnaha guud dooro Qaabka dhidibka (Format Axis), deji qiimayaasha ugu yar 0 iyo ugu badnaan la mid ah 1.Shaxda heerkulbeegga ee Excel
  5. Press Close (Xirran).

Natiijo:

Shaxda heerkulbeegga ee Excel

Leave a Reply