Speedometer Chart hauv Excel

daim ntawv qhia speedometer yog ib qho kev sib xyaw ntawm donut thiab ncuav qab zib daim ntawv. Daim duab zoo li no:

Los tsim ib daim ntawv qhia speedometer:

  1. Highlight ib qhov ntau h2:i 6.
  2. Hauv Advanced tab Insert (Ntxig) hauv ntu Kev kuaj mob (Chav) nyem Txhua daim duab (Lwm cov kab kos) thiab xaiv Annular (Doughnut).Speedometer Chart hauv Excel
  3. Tom ntej no, koj yuav tsum xaiv txhua cov ntaub ntawv taw qhia thiab siv cov lus txib Xaiv hom ntawv (Kev xaiv hom) kho qhov sau ntawm txhua lub caij. Ua tib zoo saib rau qhov piv txwv hauv qab no:
    • Rau ib tug series ntawm cov ntaub ntawvDonut» Lub sau yog teem raws li nram no: thawj peb sectors muaj ib tug txawv sau xim (liab, daj thiab lub teeb ntsuab), thiab plaub dot tsis muaj sau.
    • Rau ib tug series ntawm cov ntaub ntawvHauv pem teb» - cov ntsiab lus thawj thiab thib peb tsis tau sau, thiab qhov thib ob (qhov me tshaj plaws) yog sau nrog cov xim dub.

    Cov ntaub ntawv Series "Donut"Lossis"Hauv pem teb» tuaj yeem xaiv ntawm lub tab moj khaum (Format). Koj tuaj yeem siv tus xub yuam sij txav los ntawm ib qho ntaub ntawv mus rau lwm qhov.

    Speedometer Chart hauv Excel

  4. Xaiv cov ntaub ntawv series "Donut”, nias lub pob Xaiv hom ntawv (Kev xaiv hom) thiab nkag mus rau qhov parameter Kev sib hloov lub kaum sab xis ntawm thawj sector (Lub kaum sab xis) tus nqi 270 degrees.
  5. Xaiv daim duab, right-click rau nws, hauv cov ntawv qhia zaub mov, nyem Daim duab Area Format (Format Chart Area) thiab rau cov kev xaiv sau thiab ciam teb, xaiv raws Tsis muaj puv (Tsis yog tub) thiab tsis muaj kab (Tsis muaj kab).
  6. Rho tawm cov lus dab neeg. Qhov tshwm sim:Speedometer Chart hauv Excel
  7. Xaiv cov ntaub ntawv series "Hauv pem teb' thiab hloov hom kab ntawv rau cov koob no rau Ntu (Pib).Speedometer Chart hauv Excel
  8. Xaiv cov ntaub ntawv series "Hauv pem teb”, nias lub pob Xaiv hom ntawv (Kev xaiv hom), rau parameter Lub kaum sab xis ntawm kev sib hloov ntawm thawj cov chaw (Lub kaum sab xis) nkag mus rau tus nqi ntawm 270 degrees thiab xaiv hom kev tsim kho series me axis (secondary axis).Result. Cov ntaub ntawv Series Plot "Hauv pem teb” muaj xws li:
    • invisible colorless sector sib raug rau tus nqi 75,
    • dub sector- xub sib raug rau tus nqi 1
    • thiab lwm qhov chaw tsis muaj xim sib raug rau tus nqi 124.

    Speedometer Chart hauv Excel

  9. Siv cov kev tswj txee (Spin khawm) hloov tus nqi ntawm tes I3 los ntawm 75 mus rau 76. Ntawm daim duab ntawm cov ntaub ntawv series "Hauv pem teb» kev hloov pauv yuav tshwm sim: thawj qhov tsis muaj xim yuav cuam tshuam tus nqi 76; qhov thib ob dub yuav nyob sib npaug li 1; qhov thib peb tsis muaj xim sector yuav qhia tus nqi 200-1-76 = 123. Ua tsaug rau cov qauv hauv lub cell I3 cov sum ntawm peb sectors yuav ib txwm yog 200.Speedometer Chart hauv Excel

Sau ntawv cia Ncua