Ishadi le-thermometer ku-Excel

Kulesi sibonelo, sizokukhombisa ukuthi ungenza kanjani ishadi le-thermometer ku-Excel. Umdwebo wethemometha ukhombisa izinga lokufezwa kwenhloso.

Ukwakha ishadi le-thermometer, landela lezi zinyathelo:

  1. Gqamisa iseli B16 (leli seli akumele lithinte amanye amaseli aqukethe idatha).
  2. Kuthebhu ethuthukisiwe Faka (Faka) chofoza inkinobho Faka i-histogram (Ikholomu) bese ukhetha I-Histogram eneqoqo (Ikholomu Ehlanganisiwe).

Ishadi le-thermometer ku-Excel

Umphumela:

Ishadi le-thermometer ku-Excel

Okulandelayo, setha ishadi elidaliwe:

  1. Chofoza Inganekwane etholakala kwesokudla somdwebo bese ucindezela ukhiye kukhibhodi Susa.
  2. Shintsha ububanzi beshadi.
  3. Chofoza kwesokudla kukholomu yeshadi, kumenyu yokuqukethwe khetha Ifomethi yochungechunge lwedatha (Fometha Uchungechunge Lwedatha) kanye nepharamitha Ukususwa kohlangothi (I-Gap Width) isethwe ku-0%.
  4. Chofoza kwesokudla esikalini sephesenti eshadini, kumenyu yokuqukethwe khetha Ifomethi ye-eksisi (Fometha i-Axis), setha amanani amancane ukuze 0 kanye nobuningi obulingana no 1.Ishadi le-thermometer ku-Excel
  5. Cindezela Close (Vala).

Umphumela:

Ishadi le-thermometer ku-Excel

shiya impendulo