Thermometer chati muExcel

Mumuenzaniso uyu, tinokuratidza maitiro ekugadzira thermometer chati muExcel. Iyo thermometer dhizaini inoratidza mwero wekubudirira kwechinangwa.

Kugadzira thermometer chati, tevera matanho aya:

  1. Simbisa sero B16 (sero iri harifanire kubata mamwe maseru ane data).
  2. Pa Advanced tabo Insert (Isa) tinya bhatani Isa histogram (Column) uye sarudza Histogram pamwe nemapoka (Clustered Column).

Thermometer chati muExcel

Mhinduro:

Thermometer chati muExcel

Zvadaro, gadzira chati yakagadzirwa:

  1. Dzvanya paLegend iri kurudyi rwedhiyagiramu uye tinya kiyi pane keyboard Kudzima.
  2. Shandura hupamhi hwechati.
  3. Tinya-kurudyi pane chinyorwa chechati, mumenu yemukati sarudza Data series format (Format Data Series) uye yeparameter Side clearance (Gap Width) yakaiswa ku0%.
  4. Tinya-kurudyi pachiyero cheperesenti pachati, mumenu yemukati sarudza Axis Format (Format Axis), isa hudiki hutsika ku 0 uye yakawanda yakaenzana ne 1.Thermometer chati muExcel
  5. dzvanya pedyo (Vhara).

Mhinduro:

Thermometer chati muExcel

Leave a Reply