Mumuenzaniso uyu, tinokuratidza maitiro ekugadzira thermometer chati muExcel. Iyo thermometer dhizaini inoratidza mwero wekubudirira kwechinangwa.
Kugadzira thermometer chati, tevera matanho aya:
- Simbisa sero B16 (sero iri harifanire kubata mamwe maseru ane data).
- Pa Advanced tabo Insert (Isa) tinya bhatani Isa histogram (Column) uye sarudza Histogram pamwe nemapoka (Clustered Column).
Mhinduro:
Zvadaro, gadzira chati yakagadzirwa:
- Dzvanya paLegend iri kurudyi rwedhiyagiramu uye tinya kiyi pane keyboard Kudzima.
- Shandura hupamhi hwechati.
- Tinya-kurudyi pane chinyorwa chechati, mumenu yemukati sarudza Data series format (Format Data Series) uye yeparameter Side clearance (Gap Width) yakaiswa ku0%.
- Tinya-kurudyi pachiyero cheperesenti pachati, mumenu yemukati sarudza Axis Format (Format Axis), isa hudiki hutsika ku 0 uye yakawanda yakaenzana ne 1.
- dzvanya pedyo (Vhara).
Mhinduro: