Daim duab tso cai rau koj los soj ntsuam kev pom tseeb ntawm cov ntaub ntawv ntawm qee yam ntsuas, lossis lawv qhov muaj zog. Cov kab xaj yog siv ob qho tib si hauv kev tshawb fawb los yog hauv kev ua haujlwm, thiab hauv kev nthuav qhia. Peb saib yuav ua li cas thiaj tsim tau qhov graph hauv Microsoft Excel.
Lub phiaj xwm
Koj tuaj yeem kos lub teeb rau hauv Microsoft Excel tsuas yog tom qab lub rooj nrog cov ntaub ntawv npaj txhij, ntawm lub hauv paus uas nws yuav tsim.
Tom qab lub rooj npaj tiav, ua nyob rau hauv "Ntxig" tab, xaiv cov thaj chaw thaj chaw uas cov ntaub ntawv suav xam uas peb xav pom hauv daim duab tau nyob. Tom qab ntawv, nyob ntawm txoj hlua ntawm daim ntawv xov xwm khawm, nyem rau ntawm daim ntawv khawm.
Tom qab ntawd, ib daim ntawv teev npe qhib, hauv xya hom duab piav qhia tau nthuav tawm:
- cov sijhawm sib ntsib;
- nrog txuam nrog;
- cov sij hawm ib txwm nrog tsub zuj zuj;
- nrog rau cov cim;
- daim duab kos nrog cov cim thiab tsub cia;
- daim duab ib txwm ua cim nrog cov cim thiab tsub ntxiv;
- volumetric teeb.
Peb xaiv cov caij nyoog uas, hauv koj lub tswv yim, nws haum rau lub hom phiaj tshwj xeeb ntawm nws kev tsim kho.
Ntxiv mus, qhov kev pab cuam Microsoft Excel ua cov phiaj xwm tam sim.
Teeb duab
Tom qab lub teeb tsim, koj tuaj yeem hloov kho nws kom muab nws qhov zoo tshaj plaws uas pom tau, thiab kom nkag siab qhov nkag siab ntawm cov ntaub ntawv uas daim duab no qhia.
Txhawm rau xee lub npe ntawm daim duab, mus rau "Layout" tab ntawm daim chart wizard. Txheeb xyuas lub pob ntawm lub pob tw hauv qab "Npe Npe". Hauv daim ntawv qhib uas, xaiv qhov twg lub npe yuav raug muab tso: hauv nruab nrab lossis saum cov sijhawm teem tseg. Qhov kev xaiv thib ob yog qhov tsim nyog dua, yog li nyem rau ntawm cov khoom "Saum daim duab". Tom qab ntawd, ib lub npe tshwm uas tuaj yeem hloov lossis kho ntawm koj qhov kev txiav txim, tsuas yog nyem rau ntawm nws thiab nkag mus rau qhov cim xav tau los ntawm cov keyboard.
Txhawm rau kom muab lub npe axis ntawm kab kos, nyem rau ntawm "Axis Npe" khawm. Nyob rau hauv daim ntawv teev nco-down, tam sim ntawd xaiv yam khoom "Lub npe ntawm txoj kab rov tav tseem ceeb", thiab tom qab ntawd mus rau qhov chaw "Lub npe hauv qab kab".
Tom qab ntawd, ib daim foos rau lub npe tshwm hauv qab lub axis, rau hauv uas koj tuaj yeem nkag mus rau txhua lub npe uas koj xav tau.
Ib yam li ntawd, peb kos npe rau kab ntsug. Nyem rau ntawm "Axis Npe" khawm, tab sis hauv cov ntawv qhia zaub mov uas pom, xaiv lub npe "Npe ntawm lub ntsiab loj ntsug." Tom qab ntawd, cov npe ntawm peb qhov chaw kos npe xaiv yuav qhib:
- tig
- ntsug
- kab rov tav.
Nws yog qhov zoo uas yuav tau siv lub npe tig, raws li hauv qhov no, qhov chaw raug cawm nyob ntawm daim ntawv. Nyem rau ntawm lub npe "Rotated Name".
Ntxiv dua ntawm daim ntawv nyob ze rau qhov sib thooj axis, ib daim teb tshwm nyob rau hauv uas koj tuaj yeem nkag mus rau lub npe ntawm kab ntawv uas haum rau lub ntsiab lus ntawm cov ntaub ntawv nyob.
Yog tias koj xav tias cov lus dab neeg tsis tas yuav nkag siab txog lub sijhawm, thiab nws tsuas yog siv sijhawm hauv qhov chaw, ces koj tuaj yeem tshem tawm nws. Txhawm rau ua qhov no, nyem rau ntawm lub pob "lus dab neeg" uas nyob ntawm daim xov thiab xaiv "Tsis Pub". Koj tuaj yeem xaiv txhua txoj haujlwm ntawm zaj dab neeg yog tias koj tsis xav rho tawm nws, tab sis tsuas yog hloov chaw.
Plotting nrog kev pabcuam axis
Muaj qee qhov xwm txheej thaum koj xav tau tso ntau kab ntawm tib lub dav hlau. Yog tias lawv muaj tib lub laij tawm, tom qab ntawd qhov no tau ua raws nraim li tau piav qhia saum toj no. Tab sis dab tsi yog tias qhov ntsuas txawv?
Txhawm rau pib nrog, nyob hauv "Ntxig" tab, raws li lub sijhawm dhau los, xaiv cov nqi ntawm lub rooj. Tom ntej no, nyem rau ntawm "Daim phiaj", thiab xaiv txoj kev xaiv uas haum rau lub caij nyoog.
Raws li koj tuaj yeem pom, ob lub graphs raug tsim. Txhawm rau txhawm rau qhia lub npe tseeb ntawm chav ntsuas ntawm kev ntsuas rau txhua lub teeb, peb nyem txoj nyem rau ntawm ib qho uas peb yuav ntxiv ib txoj kab txuas ntxiv. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv cov "Format data series" item.
Cov ntaub ntawv series tawm tswv yim pib qhov rai. Hauv nws seem "Cov kab lus ntawm cov kab", uas yuav tsum qhib los ntawm lub neej ntawd, peb hloov lub khawm mus rau txoj hauj lwm "Ntawm lub ntu ntu". Nyem rau ntawm "Kaw" khawm.
Tom qab ntawd, tsim ib txoj kab sib tshooj tshiab, thiab daim duab tsim kho dua.
Tam sim no, peb tsuas yog yuav tsum kos npe rau cov paib, thiab lub npe ntawm cov duab kab xev, siv raws nraim cov teeb meem ib yam li hauv piv txwv dhau los. Yog tias muaj ob peb kab ntsuas, nws zoo dua kom tsis txhob tshem tawm cov lus dab neeg.
Muaj nuj nqi
Tam sim no cia peb paub yuav ua li cas daim phiaj ib daim duab rau ib qho kev ua haujlwm.
Cia peb muaj kev ua haujlwm y = x ^ 2-2. Cov kauj ruam yuav yog 2.
Ua ntej tshaj plaws, peb tsim lub rooj. Ntawm sab laug, sau rau x qhov tseem ceeb hauv kev nce ntxiv ntawm 2, i.e. 2, 4, 6, 8, 10, thiab lwm yam. Hauv qhov yog peb tsav hauv tus qauv.
Tom ntej no, peb tau mus rau sab hauv qab yog kaum ntawm lub xovtooj, nyem nrog khawm khawm, thiab "ncab" mus rau sab hauv qab ntawm lub rooj, yog li luam cov qauv rau lwm lub hlwb.
Tom qab ntawv, mus rau "Ntxiv rau" tab. Peb xaiv cov ntaub ntawv tab ntawm txoj haujlwm, thiab nyem rau ntawm pob "Scatter plot" ntawm txoj hlua. Los ntawm cov ntawv teev hauv daim duab piav qhia, peb xaiv daim duab kos taw tes nrog cov nkhaus du thiab cov cim, vim qhov pom no zoo tshaj rau kev ua haujlwm.
Plotting ib lub teeb muaj nuj nqi.
Tom qab lub teeb tsim tau, koj tuaj yeem rho tawm cov lus dab neeg, thiab ua kom pom qee qhov hloov pauv, uas tau tham txog saum toj no.
Raws li koj tuaj yeem pom, Microsoft Excel muaj qhov muaj peev xwm los tsim ntau yam graphs. Cov mob tseem ceeb rau qhov no yog tsim lub rooj nrog cov ntaub ntawv. Tom qab cov sijhawm tsim tsim, nws tuaj yeem hloov kho thiab kho raws li lub hom phiaj uas tau npaj.
