Microsoft Excel kev pab cuam muaj kev tsis tsuas yog ua hauj lwm nrog cov ntaub ntawv zauv, tab sis kuj muab cov cuab yeej rau lub tuam tsev tsis muaj cov kev tawm tswv yim ntawm kos duab. Nyob rau tib lub sijhawm, lawv cov duab pom tau txawv txav. Cia peb xam seb yuav siv Microsoft Excel licas los kos duab ntau ntau.
Charting ib lub rooj
Tsev ntau hom duab kos yog qhov sib luag. Tsuas yog qee lub caij koj yuav tsum xaiv hom kev tsim kom pom.
Ua ntej koj pib tsim txhua daim duab, koj yuav tsum tsim ib lub rooj nrog cov ntaub ntawv, raws li qhov uas nws yuav raug txhim tsa. Tom qab ntawd, mus rau "Insert" tab, thiab xaiv thaj chaw ntawm lub rooj no, uas yuav hais tawm hauv daim duab.
Hauv daim ntawv sau nyob rau hauv Insert tab, xaiv ib qho rau ntawm 6 hom qauv duab:
- Histogram;
- Teem caij;
- Ntu;
- Ruled;
- Nrog rau thaj chaw;
- Muaj tseeb.
Tsis tas li xwb, los ntawm qhov "Lwm Yam" khawm, koj tuaj yeem xaiv hom qis dua: daim ntawv, ntiv nplhaib, ntiv nplhaib, npuas, radar.
Tom qab ntawd, txhaj rau ib qho ntawm cov duab kos, nws raug npaj siab los xaiv ib lub subspecies. Piv txwv, rau ib lub cim histogram, los yog ib daim qauv qhia ntawv, cov ntsiab lus hauv qab no yuav yog cov hom qis: cov keeb kwm ntawm histogram, volumetric, cylindrical, conical, pyramidal.
Tom qab koj xaiv qee qhov subspecies, ib daim duab cia li raug tsim tawm. Piv txwv li, ib qho histogram yuav zoo nkaus li qhov pom tshwm hauv daim duab hauv qab no.
Daim duab hauv daim duab ntawm daim duab yuav ua raws li nram qab no.
Daim duab thaj tsam yuav zoo li no.
Ua haujlwm nrog cov kab kos
Tom qab teeb duab raug tsim, ntxiv cov cuab yeej rau kev kho thiab kho nws ua muaj nyob rau hauv tus tshiab tab "Ua hauj lwm nrog Charts". Koj tuaj yeem hloov hom qauv qhia, nws cov style, thiab lwm yam tsis muaj ntau ntxiv.
Cov "Ua Haujlwm Nrog Cov Ntaus" tab muaj peb qhov kev pab ntxiv: "Constructor", "Layout" and "Format".
Yuav kom tau lub npe rau daim ntawv qhia, mus rau "Layout" tab, thiab xaiv ib qho ntawm cov kev xaiv rau qhov chaw ntawm lub npe: nyob rau hauv qhov chaw lossis siab tshaj ntawm daim phiaj.
Tom qab qhov no tiav lawm, tus qauv npe "Chart Name" tshwm. Hloov rau txhua daim ntawv qhia uas muaj qhov sib txawv ntawm cov ntsiab lus ntawm lub rooj ntawv no.
Cov npe ntawm daim duab ntawm daim duab yog kos npe raws nraim tib lub hauv paus, tab sis rau qhov no koj yuav tsum nias lub khawm "Axes npe".
Feem pua Daim Ntawv Qhia
Yuav kom pom cov feem pua ntawm ntau yam kev ntsuas, nws yog qhov zoo tshaj plaws los tsim ib lub khoom noj qab zib.
Nyob rau tib txoj kev raws li peb tau ua los saum no, peb txhim tsa ib lub rooj, ces xaiv qhov yam xav tau ntawm nws. Tom ntej no, mus rau "Insert" tab, xaiv ib lub khoom noj qab zib ntawm daim ntawv sau, thiab tom qab ntawd, hauv daim ntawv uas tshwm sim, nyem rau ntawm txhua hom khoom noj qab zib.
Tsis tas li ntawd, qhov kev pab cuam ntawm nws tus kheej tau muab txhais ua ib qho ntawm cov tabs ua haujlwm nrog kos duab - "Designer". Xaiv cov teeb duab ntawm cov duab kos rau hauv cov ntawv xov xwm uas muaj qhov cim ntawm feem pua tam sim no.
Lub ncuav qab zib nrog cov pua pua ntaub ntawv npaj txhij.
Pareto Charting
Raws li txoj kev xav ntawm Wilfredo Pareto, 20% ntawm cov kev ua haujlwm zoo coj 80% ntawm tag nrho cov txiaj ntsim. Raws li, ntxiv 80% ntawm tag nrho cov txheej txheem uas tsis siv, tsuas yog 20% ntawm qhov tshwm sim. Kev tsim kho ntawm Pareto daim ntawv qhia yog los xam cov haujlwm zoo tshaj plaws uas muab qhov nyiaj siab tshaj plaws. Peb ua qhov no nrog kev pab los ntawm Microsoft Excel.
Nws yog qhov yooj yim tshaj plaws kom tsim tau ib qho Pareto daim ntawv qhia nyob rau hauv daim ntawv ntawm ib tug histogram, uas peb twb hais saum toj no.
Ib qho piv txwv ntawm kev tsim kho. Rooj ntawv qhia txog cov khoom noj. Ib kem muaj tus nqi ntawm tag nrho cov ntim ntawm ib hom khoom ntawm cov khoom lag luam wholesale, thiab qhov thib ib yog cov nyiaj ntawm nws cov muag. Peb yuav tsum txiav txim siab seb cov khoom muab qhov khoom loj tshaj "rov qab" hauv qhov muag.
Ua ntej tshaj, peb tsim ib qho histogram. Mus rau "Insert" tab, xaiv tag nrho ntawm qhov tseem ceeb ntawm lub rooj, nyem qhov "Histogram" khawm, thiab xaiv yam yam histogram.
Raws li koj tau pom, vim tias cov kev ua no, ib daim duab tau tsim nrog ob hom kab twg: xiav thiab liab.
Tam sim no, peb yuav tsum hloov cov kab liab hauv ib daim duab. Ua li no, xaiv cov kab nrog tus cursor, thiab hauv "Designer" tab, nias qhov "Change chart type".
Daim ntawv nthuav qhia hom hloov opens. Mus rau seem "Tshawb", thiab xaiv hom kos duab rau peb lub hom phiaj.
Yog li, Pareto daim duab yog tsim. Tam sim no, koj tuaj yeem hloov nws lub ntsiab (lub npe ntawm daim phiaj thiab lub tsho, kev cai, thiab lwm yam), raws li nws tau piav qhia siv cov qauv ntawm ib qho qauv qhia ntawv.
Raws li koj tau pom, Microsoft Excel nthuav dav dav cov cuab yeej rau kev tsim kho thiab kho ntau hom kab kos. Feem ntau, txoj hauj lwm nrog cov cuab yeej no yog yooj yim los ntawm cov neeg tsim khoom kom ntau li ntau tau kom cov neeg siv ntau qib kev cob qhia tuaj yeem tiv thaiv nrog lawv.
