Thermometer chart hauv Excel

Hauv qhov piv txwv no, peb yuav qhia koj yuav ua li cas los tsim ib daim ntawv ntsuas kub hauv Excel. Daim duab ntsuas kub qhia txog qib kev ua tiav ntawm lub hom phiaj.

Txhawm rau tsim daim ntawv ntsuas ntsuas kub, ua raws li cov kauj ruam no:

  1. Highlight ib cell B16 (Lub cell no yuav tsum tsis txhob kov lwm lub cell uas muaj cov ntaub ntawv).
  2. Hauv Advanced tab Insert (Ntxig) nyem lub pob Ntxig histogram (Kem) thiab xaiv Histogram nrog pab pawg (Clustered Kem).

Thermometer chart hauv Excel

Tshwm sim:

Thermometer chart hauv Excel

Tom ntej no, teeb tsa daim duab tsim:

  1. Nyem rau ntawm cov lus dab neeg nyob rau sab xis ntawm daim duab thiab nias tus yuam sij ntawm cov keyboard Rho tawm.
  2. Hloov daim duab dav.
  3. Right-click ntawm kab ntawv kab ntawv, hauv cov ntawv qhia zaub mov xaiv Cov ntaub ntawv series (Format Data Series) thiab rau qhov parameter Sab clearance (Gap Width) teem rau 0%.
  4. Txoj cai-nias ntawm qhov feem pua ​​​​ntawm cov ntawv teev lus, hauv cov ntawv qhia zaub mov xaiv Axis Format (Format Axis), teem qhov tsawg kawg nkaus qhov tseem ceeb rau 0 thiab siab tshaj plaws sib npaug 1.Thermometer chart hauv Excel
  5. Xovxwm Close (Kaw).

Tshwm sim:

Thermometer chart hauv Excel

Sau ntawv cia Ncua