Yog tias koj tab tom nrhiav txoj hauv kev niaj hnub los pom cov ntaub ntawv, saib ntawm Excel saib daim ntawv qhia ntsej muag. Daim ntawv xov tooj hu tau raug tsim los kho lub dashboard, thiab vim nws zoo ib yam li lub tsheb speedometer, nws tseem hu ua daim ntawv ntsuas ntsuas.
Daim ntawv qhia lub ntsej muag moos yog qhov zoo rau kev qhia txog qib kev ua tau zoo thiab qhov tseem ceeb.
Kauj ruam zuj zus:
- Tsim ib kab hauv lub rooj Dial (uas txhais tau hais tias tus hu) thiab hauv nws thawj lub xov tooj peb nkag mus rau tus nqi 180. Tom qab ntawd peb nkag mus rau qhov ntau ntawm cov ntaub ntawv uas qhia txog kev ua tau zoo, pib nrog qhov tsis zoo. Cov txiaj ntsig no yuav tsum yog ib feem ntawm 180. Yog tias cov ntaub ntawv qub tau nthuav tawm raws li feem pua, ces nws tuaj yeem hloov mus rau qhov tseem ceeb los ntawm kev muab faib los ntawm 180 thiab faib los ntawm 100.
- Highlight ib kem Dial thiab tsim ib daim ntawv qhia donut. Txhawm rau ua qhov no, ntawm lub tab Insert (Ntxig) hauv ntu Kev kuaj mob (Cov kab kos) nyem lub xub me nyob rau sab xis sab xis (pom hauv daim duab hauv qab).
- Ib lub dialog box yuav qhib Ntxig ib daim duab (Insert chart). Qhib ib lub tab Txhua daim duab (Tag nrho cov kab kos) thiab hauv cov ntawv qhia zaub mov ntawm sab laug, nyem Ntu (Pie). Xaiv los ntawm cov subtypes pom zoo nplhaib (Doughnut) daim ntawv qhia thiab nias OK.
- Daim duab yuav tshwm rau ntawm daim ntawv. Yuav kom nws zoo li lub dial tiag, koj yuav tsum tau hloov nws cov tsos.
- Xaiv lub ntsiab lus 2 hauv cov ntaub ntawv series Dial. Hauv vaj huam sib luag Cov ntaub ntawv point format (Format Data Point) hloov qhov parameter Kev sib hloov lub kaum sab xis ntawm thawj sector (Lub kaum sab xis ntawm Thawj ntu) ntawm 90 °.
- Xaiv lub ntsiab lus 1 thiab hauv vaj huam sib luag Cov ntaub ntawv point format (Format Data Point) hloov qhov sau rau Tsis muaj puv (Tsis Sau).
Daim ntawv qhia tam sim no zoo li daim ntawv hu. Nws tseem yuav ntxiv ib xub rau lub dial!
Txhawm rau ntxiv tus xub, koj xav tau lwm daim ntawv qhia:
- Ntxig ib kab thiab sau tus nqi 2. Ntawm kab tom ntej, sau tus nqi 358 (360-2). Ua kom tus xub dav dua, nce tus nqi thawj zaug thiab txo qhov thib ob.
- Xaiv kem thiab tsim daim ntawv qhia ncuav qab zib los ntawm nws ib yam li tau piav ua ntej hauv kab lus no (qib 2 thiab 3) los ntawm kev xaiv Ntu daim duab hloov Annular.
- Hauv panels Cov ntaub ntawv series (Format Data Series) hloov qhov sau ntawm qhov loj dua ntawm daim ntawv rau Tsis muaj puv (Tsis muaj sau) thiab ciam teb rau tsis muaj ciam teb (Tsis muaj ciam teb).
- Xaiv qhov me me ntawm daim ntawv qhia uas yuav ua raws li tus xub thiab hloov ciam teb rau tsis muaj ciam teb (Tsis muaj ciam teb). Yog tias koj xav hloov cov xim ntawm tus xub, xaiv qhov kev xaiv khoom puv (Tshuaj Fill) thiab xim haum.
- Nyem rau ntawm qhov keeb kwm yav dhau ntawm daim duab qhia chaw thiab hauv lub vaj huam sib luag uas tshwm sim, hloov qhov sau rau Tsis muaj puv (Tsis Sau).
- Nyem lub cim icon ntxiv rau (+) rau cov ntawv qhia zaub mov ceev Daim ntawv qhia (Chart Elements) thiab uncheck lub thawv nyob ib sab ntawm lus dab neeg (Legend) thiab lub npe (Tswj lub npe).
- Tom ntej no, tso tes saum lub dial thiab tig nws mus rau qhov xav tau txoj hauj lwm uas siv cov parameter Kev sib hloov lub kaum sab xis ntawm thawj sector (Lub Kaum Ib Hlis).
Npaj txhij! Peb nyuam qhuav tsim daim ntawv qhia ntsej muag saib!