Yuav Ua Li Cas Tsim Daim Duab Hauv Excel

Cov txheej txheem:

Yuav Ua Li Cas Tsim Daim Duab Hauv Excel
Yuav Ua Li Cas Tsim Daim Duab Hauv Excel

Video: Yuav Ua Li Cas Tsim Daim Duab Hauv Excel

Video: Yuav Ua Li Cas Tsim Daim Duab Hauv Excel
Video: koj xav muaj peev nyiaj yuav tsim li cas? peev los qhov twg los? clip no muaj lus teb (05) 2024, Hlis ntuj nqeg
Anonim

Kev ua piv txwv ntawm cov kev suav suav hauv daim ntawv ntawm cov duab kos duab thiab cov duab piav qhia yog lub sijhawm zoo rau kev npaj cov ntawv tshaj qhia kom pom ntau dua. Cov ntaub ntawv nthuav tawm nyob rau hauv daim ntawv ntawm cov duab pom yog ntau zoo dua nco. Ib txoj hauv kev los txhim kho qhov kev pom ntawm cov txiaj ntsig ntawm txoj kev tshawb no yog txhais cov txheeb cais qhuav mus rau hauv cov duab pom ntawm Excel cov duab kos.

Yuav tsim daim phiaj hauv Excel li cas
Yuav tsim daim phiaj hauv Excel li cas

Cov Lus Qhia

Kauj ruam 1

Txhawm rau tsim ib daim duab hauv Excel, sau cov ntaub ntawv xav tau hauv daim foos. Xaiv lawv cov kab ntawv tag nrho thiab nyem rau ntawm "Daim Ntawv Qhia" ntawm lub pob khoom siv. Qhov zoo sib xws yuav tshwm sim yog tias koj xaiv lo lus "Diagram …" los ntawm "Ntxig" ntawv qhia zaub mov.

Kauj ruam 2

Nyob rau hauv lub qhov rai uas tshwm, xaiv hom qauv uas haum rau. Daim duab twg xaiv raws li cov ntaub ntawv uas koj sau rau hauv yuav ua piv txwv, nrog rau koj lub siab nyiam. Cov kev suav daws niaj hnub zoo saib rau hauv daim ntawv ntawm ib txwm muaj cov histogram, uas tuaj yeem muab ib qho zoo nkauj rau lub sijhawm. Nyob rau tib lub sijhawm, cov feem pua yooj yim, nrog rau cov rooj sib xyaw ntawm ob kab, tau nkag siab zoo hauv daim ntawv ntawm daim duab qhia cov ncuav qab zib, raws li ib qho kev xaiv - cov kab kos nrog cov ntawv sau tseg.

Kauj ruam 3

Hauv lub vauj txuas tom ntej, hais kom meej cov thaj tsam ntawm cov ntaub ntawv siv. Txhawm rau teeb daim phiaj hauv Excel, kuj nkag rau X thiab Y axis cov ntawv raws li xav tau. Xaiv tau, hais kom meej yog tias koj xav ntxiv ib qho lus dab neeg rau hauv cov duab kos thiab sau npe rau ntawm txiaj ntsig. Tom qab ntawd xaiv qhov chaw nyob ntawm daim duab: ntawm tib daim ntawv raws li lub rooj nrog cov ntaub ntawv nws tus kheej, lossis ntawm nyias daim Excel. Nyob rau hauv rooj plaub tom kawg, lub rooj yuav noj tag nrho qhov chaw ntawm daim ntawv tshiab, thiab thaum luam, nws yog qhov loj rau ntawm qhov loj ntawm daim ntawv rau luam ntawv.

Kauj ruam 4

Tom qab ntawd, koj tuaj yeem hloov qhov tshwm sim thiab cov kev teeb tsa ntawm daim duab los ntawm txoj cai-nias ntawm nws thaj chaw thiab xaiv ib qho ntawm cov lus txib los ntawm daim ntawv teev cia-nqis: hom, cov ntaub ntawv, cov lus qhia thiab thaj chaw.

Pom zoo: