txheem
Kev pom kev nthuav qhia cov ntaub ntawv pab txhawb nws txoj kev xav. Tej zaum txoj kev yooj yim tshaj plaws los hloov cov ntaub ntawv qhuav rau hauv daim ntawv uas pom tau tias yog tsim cov duab thiab cov ntxhuav. Tsis muaj tus kws tshuaj ntsuam ua tau yam tsis muaj lawv.
Graphs muaj ntau qhov zoo dua lwm txoj hauv kev ntawm kev nthuav tawm cov ntaub ntawv. Ua ntej, lawv tso cai rau koj kom ua tiav cov lej muaj txiaj ntsig thiab ua qee yam kev twv ua ntej. Ntawm lwm yam, kev npaj tso cai rau koj los xyuas qhov siv tau ntawm cov ntaub ntawv muaj lej, vim tias qhov tsis raug yuav tshwm sim tom qab tsim lub sijhawm.
Ua tsaug rau Vajtswv Excel ua rau tsim cov kab kos ib txoj kev yooj yim thiab yooj yim, tsuas yog ua raws li tus lej uas twb muaj lawm.
Tsim ib daim duab hauv Excel yog ua tau nyob rau hauv ntau txoj kev, txhua tus muaj qhov zoo thiab cov kev txwv tseem ceeb. Tab sis cia saib txhua yam hauv kev nthuav dav ntxiv.
Elementary hloov daim duab
Ib daim duab xav tau yog tias tus neeg yuav tsum tau ua kom pom ntau npaum li cas qhov ntsuas tau hloov pauv hauv lub sijhawm tshwj xeeb. Thiab cov duab ib txwm muaj txaus los ua kom tiav txoj haujlwm no, tab sis ntau daim duab qhia tau yooj yim tsuas yog ua kom cov ntaub ntawv nyeem tsawg dua.
Piv txwv tias peb muaj ib lub rooj uas muab cov ntaub ntawv hais txog ib lub tuam txhab cov nyiaj tau los ntawm tsib xyoos dhau los.
Tseem ceeb heev. Cov duab no tsis sawv cev rau cov ntaub ntawv tiag tiag thiab tej zaum yuav tsis muaj tseeb. Lawv muab rau kev kawm nkaus xwb.
Tom qab ntawd mus rau "Ntxig" tab, qhov twg koj muaj sijhawm los xaiv hom kab ntawv uas yuav haum rau ib qho xwm txheej tshwj xeeb.
Peb txaus siab rau hom "Graph". Tom qab txhaj rau ntawm lub pob sib txuas, lub qhov rai uas muaj teeb tsa rau cov tsos ntawm daim duab yav tom ntej yuav tshwm sim. Txhawm rau nkag siab qhov kev xaiv twg yog qhov tsim nyog nyob rau hauv ib qho xwm txheej, koj tuaj yeem txav koj tus nas hla ib hom tshwj xeeb thiab cov lus ceeb toom yuav tshwm sim.
Tom qab xaiv hom kab ntawv uas xav tau, koj yuav tsum luam cov ntaub ntawv cov lus thiab txuas mus rau daim duab. Qhov tshwm sim yuav yog cov hauv qab no.
Hauv peb qhov xwm txheej, daim duab qhia ob kab. Thawj tus yog liab. Qhov thib ob yog xiav. Peb tsis xav tau tom kawg, yog li peb tuaj yeem tshem nws los ntawm kev xaiv nws thiab nyem lub pob "Delete". Txij li thaum peb tsuas muaj ib kab xwb, cov lus dab neeg (ib qho thaiv nrog cov npe ntawm cov kab kos duab) kuj tuaj yeem raug tshem tawm. Tab sis cov cim npe zoo dua. Nrhiav cov cuab yeej cuab yeej vaj huam sib luag thiab cov ntaub ntawv cov ntawv thaiv ntawm lub Layout tab. Ntawm no koj yuav tsum txiav txim siab txoj haujlwm ntawm cov lej.
Cov axes raug pom zoo kom muaj npe los muab kev nyeem tau ntau dua ntawm daim duab. Nyob rau ntawm Layout tab, nrhiav cov ntawv qhia zaub mov Axis Titles thiab teeb lub npe rau cov kab ntsug lossis kab rov tav, ntsig txog.
Tab sis koj tuaj yeem ua tau yam tsis muaj header. Txhawm rau tshem tawm nws, koj yuav tsum tau txav mus rau thaj tsam ntawm daim duab uas pom tsis pom qhov muag (saum toj no). Yog tias koj tseem xav tau daim ntawv teev npe, koj tuaj yeem nkag mus rau txhua qhov chaw tsim nyog los ntawm "Chat Title" ntawv qhia zaub mov ntawm tib lub tab. Koj tuaj yeem pom nws hauv qab Layout tab.
Hloov chaw ntawm tus lej xov tooj ntawm lub xyoo tshaj tawm, nws txaus los tawm tsuas yog lub xyoo xwb. Xaiv qhov xav tau qhov tseem ceeb thiab right-click rau lawv. Tom qab ntawd nyem rau ntawm "Xaiv cov ntaub ntawv" - "Hloov kab rov tav Axis Label". Tom ntej no, koj yuav tsum tau teem caij. Nyob rau hauv peb rooj plaub, qhov no yog thawj kab ntawm lub rooj uas yog lub hauv paus ntawm cov ntaub ntawv. Qhov tshwm sim yog qhov no.
Tab sis feem ntau, koj tuaj yeem tawm txhua yam, lub sijhawm no ua haujlwm heev. Tab sis yog tias muaj qhov xav tau los ua kom zoo nkauj ntawm daim duab, ces "Designer" tab yog nyob ntawm koj qhov kev pabcuam, uas tso cai rau koj qhia cov xim tom qab ntawm daim duab, nws cov font, thiab tseem muab tso rau hauv lwm daim ntawv.
Tsim ib daim phiaj nrog ntau qhov nkhaus
Piv txwv tias peb yuav tsum ua kom pom tseeb rau cov tub ua lag luam tsis yog tsuas yog cov nyiaj tau los ntawm lub tuam txhab, tab sis kuj tseem yuav raug nqi npaum li cas ntawm nws cov cuab tam. Raws li, cov ntaub ntawv ntau ntxiv tau nce.
Txawm hais tias qhov no, tsis muaj qhov sib txawv hauv cov qauv ntawm kev tsim cov duab piv rau cov uas tau piav saum toj no. Nws tsuas yog hais tias tam sim no cov lus dab neeg yuav tsum tau tso tseg, vim tias nws txoj haujlwm ua tau zoo kawg nkaus.
Tsim ib tug thib ob axis
Yuav ua li cas yuav tsum tau ua los tsim lwm axis ntawm daim ntawv? Yog tias peb siv cov metric units, ces cov lus qhia tau piav qhia ua ntej yuav tsum tau siv. Yog tias siv cov ntaub ntawv sib txawv, ces ib qho ntxiv yuav tsum tau muab ntxiv.
Tab sis ua ntej ntawd, koj yuav tsum tsim ib daim duab tsis tu ncua, zoo li yog siv tib lub ntsuas ntsuas.
Tom qab ntawd, lub ntsiab axis yog highlighted. Tom qab ntawd hu rau cov ntawv qhia zaub mov. Yuav muaj ntau yam khoom hauv nws, ib qho yog "Cov Ntaub Ntawv Series". Nws yuav tsum tau nias. Tom qab ntawd lub qhov rais yuav tshwm nyob rau hauv uas koj yuav tsum nrhiav cov ntawv qhia zaub mov "Law Options", thiab ces teem qhov kev xaiv "Nrog rau lub axis auxiliary".
Tom ntej no, kaw lub qhov rais.
Tab sis qhov no tsuas yog ib txoj hauv kev ua tau. Tsis muaj leej twg thab, piv txwv li, siv daim duab ntawm ib hom sib txawv rau cov axis thib ob. Peb yuav tsum txiav txim siab seb kab twg xav kom peb ntxiv ib qho axis ntxiv, thiab tom qab ntawd nyem rau ntawm nws thiab xaiv "Hloov kab ntawv rau Series".
Tom ntej no, koj yuav tsum tau kho qhov "zoo" ntawm kab thib ob. Peb txiav txim siab los lo nrog daim ntawv qhia bar.
Nov yog qhov yooj yim npaum li cas. Nws yog txaus kom tsuas yog ob peb clicks, thiab lwm axis tshwm, configured rau ib tug txawv parameter.
Excel: Cov txheej txheem los tsim ib daim duab ntawm lub luag haujlwm
Qhov no twb yog ib txoj hauj lwm tsis tseem ceeb dua, thiab txhawm rau ua kom tiav, koj yuav tsum ua ob kauj ruam tseem ceeb:
- Tsim ib lub rooj uas ua haujlwm raws li cov ntaub ntawv. Ua ntej koj yuav tsum txiav txim siab seb qhov haujlwm twg yuav raug siv tshwj xeeb hauv koj rooj plaub. Piv txwv li, y = x(√x – 2). Hauv qhov no, peb yuav xaiv tus nqi 0,3 raws li cov kauj ruam siv.
- Qhov tseeb, tsim ib daim duab.
Yog li, peb yuav tsum tsim ib lub rooj nrog ob kab. Qhov thib ib yog kab rov tav axis (uas yog X), qhov thib ob yog ntsug (Y). Cov kab thib ob muaj thawj tus nqi, hauv peb cov ntaub ntawv nws yog ib qho. Ntawm kab thib peb, koj yuav tsum sau tus nqi uas yuav yog 0,3 ntau dua li yav dhau los. Qhov no tuaj yeem ua tiav ob qho tib si nrog kev pab los ntawm kev suav ywj pheej, thiab los ntawm kev sau cov qauv ncaj qha, uas nyob rau hauv peb rooj plaub yuav ua raws li hauv qab no:
=A2+0,3.
Tom qab ntawd, koj yuav tsum siv autocomplete rau cov hlwb hauv qab no. Txhawm rau ua qhov no, xaiv cov hlwb A2 thiab A3 thiab luag lub thawv rau cov kab uas xav tau.
Hauv kab ntsug, peb qhia cov qauv siv los npaj cov duab ua haujlwm raws li cov qauv tiav. Hauv peb qhov piv txwv, qhov no yuav yog =A2*(ROOT(A2-2). Tom qab ntawd, nws lees paub nws qhov kev ua nrog tus yuam sij Enter, thiab qhov kev zov me nyuam yuav txiav txim siab qhov tshwm sim.
Tom ntej no, koj yuav tsum tsim ib daim ntawv tshiab lossis hloov mus rau lwm qhov, tab sis twb muaj lawm. Muaj tseeb tiag, yog tias muaj qhov xav tau ceev, koj tuaj yeem ntxig daim duab ntawm no (tsis tau khaws ib daim ntawv cais rau txoj haujlwm no). Tab sis tsuas yog nyob rau hauv cov xwm txheej uas muaj ntau qhov chaw dawb. Tom qab ntawd nyem cov khoom nram qab no: "Ntxig" - "Daim ntawv qhia" - "Scatter".
Tom qab ntawd, koj yuav tsum txiav txim siab seb hom kab ntawv twg koj xav siv. Tsis tas li ntawd, txoj cai nas nyem yog ua rau ntawm qhov chaw ntawm daim duab uas cov ntaub ntawv yuav raug txiav txim. Ntawd yog, tom qab qhib cov ntawv qhia zaub mov, koj yuav tsum nyem rau ntawm "Xaiv cov ntaub ntawv" khawm.
Tom ntej no, koj yuav tsum xaiv thawj kab, thiab nyem "Ntxiv". Lub dialog box yuav tshwm sim, qhov twg yuav muaj kev teeb tsa rau lub npe ntawm cov koob, nrog rau cov txiaj ntsig ntawm kab rov tav thiab ntsug axes.
Hurray, qhov tshwm sim yog, thiab nws zoo nkaus li zoo heev.
Ib yam li cov duab tsim thaum pib, koj tuaj yeem tshem tawm cov lus dab neeg, vim peb tsuas muaj ib kab xwb, thiab tsis tas yuav tsum tau sau ntxiv rau nws.
Tab sis muaj ib qho teeb meem - tsis muaj qhov tseem ceeb ntawm X-axis, tsuas yog tus naj npawb ntawm cov ntsiab lus. Txhawm rau kho qhov teeb meem no, koj yuav tsum sau lub npe no. Txhawm rau ua qhov no, koj yuav tsum tau nyem rau ntawm nws, thiab tom qab ntawd xaiv "Xaiv Cov Ntaub Ntawv" - "Hloov kab rov tav Axis Labels". Thaum ua tiav cov haujlwm no, cov txheej txheem yuav tsum tau xaiv, thiab daim duab yuav zoo li no.
Yuav ua li cas sib koom ua ke ntau daim duab
Txhawm rau tsim ob daim duab ntawm tib daim teb, koj tsis tas yuav muaj peev xwm tshwj xeeb. Txhawm rau pib, koj yuav tsum ntxiv kab ntawv txuas ntxiv nrog cov haujlwm Z = X(√x - 3).
Yuav kom paub meej, ntawm no yog lub rooj.
Peb nrhiav cov hlwb nrog cov ntaub ntawv xav tau thiab xaiv lawv. Tom qab ntawd, lawv yuav tsum tau muab tso rau hauv daim duab. Yog tias ib yam dab tsi tsis ua raws li kev npaj (piv txwv li, cov npe tsis raug lossis cov lej tsis raug ntawm lub axis raug sau tsis raug), ces koj tuaj yeem siv cov khoom "Xaiv cov ntaub ntawv" thiab kho lawv. Yog li ntawd, ib daim duab zoo li no yuav tshwm sim, qhov twg ob kab sib xyaw ua ke.
Dependency Plots
Qhov no yog hom duab uas cov ntsiab lus ntawm ib kab lossis kab ncaj qha cuam tshuam rau qhov tshwm sim ntawm lwm qhov. Txhawm rau tsim nws, koj yuav tsum tsim ib lub phaj zoo li no.
Teem caij tej yam kev mob: AB = f(E); В = f(E); C = f (E); D = f (E).
Hauv peb qhov xwm txheej, peb yuav tsum nrhiav cov phiaj xwm tawg nrog cov cim thiab cov nkhaus nkhaus, vim tias hom no zoo tshaj plaws rau peb txoj haujlwm. Ces nyem rau ntawm cov nyees khawm nram qab no: Xaiv cov ntaub ntawv – Ntxiv. Cia lub npe kab yog "A" thiab X qhov tseem ceeb yog qhov txiaj ntsig A. Nyob rau hauv lem, qhov ntsug qhov tseem ceeb yuav yog E qhov tseem ceeb. Nyem "Ntxiv" dua. Cov kab thib ob yuav raug hu ua B, thiab qhov tseem ceeb nyob ntawm X axis yuav nyob rau hauv kab B, thiab raws li txoj kab ntsug - hauv kab E. Tsis tas li ntawd, tag nrho lub rooj yog tsim los ntawm cov txheej txheem no.
Customizing qhov tshwm sim ntawm Excel Graph
Tom qab tsim daim ntawv qhia, koj yuav tsum tau them nyiaj tshwj xeeb rau kev teeb tsa. Nws yog ib qho tseem ceeb uas nws cov tsos yog txaus nyiam. Cov hauv paus ntsiab lus ntawm kev teeb tsa yog tib yam, tsis hais qhov version ntawm qhov kev pab cuam siv.
Nws yog ib qho tseem ceeb kom nkag siab tias txhua daim duab yog inherently ib yam khoom complex. Yog li ntawd, nws suav nrog ntau qhov me me. Txhua tus ntawm lawv tuaj yeem teeb tsa los ntawm kev hu rau cov ntawv qhia zaub mov.
Ntawm no koj yuav tsum paub qhov txawv ntawm qhov teeb tsa qhov dav dav ntawm daim ntawv qhia thiab cov khoom tshwj xeeb. Yog li, txhawm rau txhim kho nws cov yam ntxwv tseem ceeb, koj yuav tsum nyem rau ntawm qhov keeb kwm yav dhau ntawm daim duab. Tom qab ntawd, qhov kev zov me nyuam yuav qhia ib lub vaj huam sib luag mini uas koj tuaj yeem tswj hwm cov ntsiab lus dav dav, nrog rau ntau yam khoom noj uas koj tuaj yeem teeb tsa lawv yooj yim dua.
Txhawm rau teeb tsa keeb kwm yav dhau los ntawm daim duab, koj yuav tsum xaiv cov khoom "Chat Area Format". Yog tias cov khoom ntawm cov khoom tshwj xeeb raug kho, ces tus naj npawb ntawm cov ntawv qhia zaub mov yuav txo qis. Piv txwv li, txhawm rau hloov cov lus dab neeg, tsuas yog hu rau cov ntawv qhia zaub mov thiab nyem rau ntawm qhov khoom ntawd, uas ib txwm pib nrog lo lus "Format". Koj tuaj yeem pom nws nyob hauv qab ntawm cov ntawv qhia zaub mov.
Cov lus qhia dav dav rau kev tsim cov duab kos
Muaj ntau cov lus qhia txog yuav ua li cas tsim cov duab kom zoo kom lawv nyeem tau thiab paub:
- Koj tsis tas yuav siv cov kab ntau dhau. Tsuas yog ob lossis peb zaug xwb. Yog tias koj xav tau tso saib cov ntaub ntawv ntxiv, nws yog qhov zoo dua los tsim cov duab cais.
- Koj yuav tsum tau them nyiaj tshwj xeeb rau cov lus dab neeg, nrog rau cov axes. Lawv tau kos npe zoo npaum li cas nyob ntawm seb nws yuav yooj yim npaum li cas los nyeem daim ntawv qhia. Qhov no yog ib qho tseem ceeb vim hais tias ib daim duab yog tsim los ua kom yooj yim rau kev nthuav qhia ntawm tej yam ntaub ntawv, tab sis yog mus cuag irresponsibly, nws yuav nyuaj rau ib tug neeg to taub.
- Txawm hais tias koj tuaj yeem kho qhov tsos ntawm daim ntawv, nws tsis pom zoo kom siv ntau xim. Qhov no yuav cuam tshuam tus neeg nyeem cov duab kos.
cov lus xaus
Hauv cov lus yooj yooj yim, nws yooj yim kiag li los tsim ib daim duab uas siv ntau yam ntawm cov txiaj ntsig raws li cov ntaub ntawv. Nws yog txaus los nias ob peb lub nyees khawm, thiab qhov kev zov me nyuam yuav ua tus so ntawm nws tus kheej. Ntawm chav kawm, rau kev paub txog cov cuab yeej no, koj yuav tsum xyaum me ntsis.
Yog tias koj ua raws li cov lus qhia dav dav rau kev tsim cov kab kos, nrog rau kev tsim cov duab kos zoo nkauj hauv txoj hauv kev uas koj tau txais cov duab zoo nkauj heev thiab cov ntaub ntawv uas yuav tsis ua rau muaj teeb meem thaum nyeem nws.