Tsim thiab Hom Ntawv Tus Kab teeb hauv Excel hauv 5 Cov Kauj Ruam

Thaum koj xav tau ib txoj kab, muaj cov tswv yim yooj yim los siv

Nyob rau hauv Microsoft Excel, ntxiv cov kab ua kab rau ib daim ntawv los yog cov phau ntawv ua haujlwm ua ib qho sawv cev ntawm cov ntaub ntawv. Qee lub sijhawm, daim duab ntawm cov ntaub ntawv tuaj yeem tshwm sim tawm thiab hloov tau tias lwm txoj kev tsis paub tias thaum twg cov ntaub ntawv raug muab faus rau hauv kab thiab kab.

Tsim Kab Kab - Cov Luv Version

Cov kauj ruam los mus ntxiv cov kab sau kab los yog cov kab hauv kab rau daim ntawv ua haujlwm Excel yog:

1. Tshawb cov ntaub ntawv yuav tsum muaj nyob hauv daim graph - muaj cov kab ntawv thiab cov kab taub sab tab sis tsis yog lub npe rau cov lus qhia.
2. Nias rau ntawm daim ntxig ntawm daim ntawv sau .
3. Hauv ntu Tshooj lus ntawm kab ntawv, nias ntawm kab Insert Line Chart icon qhib lub npe ntawm cov ntawv sau / kos duab.
4. Hover koj tus pointer nas hla ib hom ntawv nyeem nyeem cov lus piav qhia ntawm daim phiaj / daim duab.
5. Ndliv lub nraaj rua.

Daim phiaj dawb, unformatted - ib qho uas qhia txog cov kab uas sawv cev ntawm cov xaiv ntawm cov ntaub ntawv , lub npe ntawm daim ntawv pov thawj, cov lus dab neeg, thiab qhov tseem ceeb - yuav muab ntxiv rau daim ntawv ua haujlwm tam sim no.

Version txawv

Cov kauj ruam hauv cov ntawv nyeem no siv qhov kev teeb tsa thiab kev xaiv teeb tsa muaj nyob rau hauv Excel 2013. Cov no txawv ntawm cov neeg pom nyob rau hauv thaum ntxov versions ntawm qhov kev pab cuam. Siv cov kev txuas mus ntxiv nram qab no rau cov kab hauv cov qauv kev nyeem ntawv rau lwm cov qauv ntawm Excel.

• Excel 2010 thiab 2007 Cov Kab Xam Pom
• Excel 2003 (thiab yav dhau los versions) Cov Kab Xam Tawm

Ib qho lus qhia txog Excel lub ntsiab xim

Excel, zoo li tag nrho Microsoft Office cov kev pabcuam, siv cov ntsiab lus los tsim qhov zoo ntawm nws cov ntaub ntawv. Nyob ntawm cov ntsiab lus uas koj siv thaum uas ua raws li qhov kev qhia no, cov xim uas teev rau hauv cov kauj ruam hauv kev nyeem ntawv yuav tsis zoo ib yam li cov uas koj siv. Koj tuaj yeem xaiv cov ntsiab lus uas koj xav tau thiab ua tau.

Ua Tus Kab Teeb - Lub Ntev Version

Lus Cim: Yog tias koj tsis muaj cov ntaub ntawv ntawm tes siv nrog qhov kev qhia no, cov kauj ruam hauv phau ntawv no ua kom siv cov ntaub ntawv qhia hauv daim duab saum toj no.

Nkag mus rau lwm cov ntaub ntawv yeej yog thawj kauj ruam hauv kev tsim ib lub teeb - tsis muaj teeb meem dab tsi los yog hom ntawv teeb.

Cov kauj ruam thib ob yog qhov tseem ceeb ntawm cov ntaub ntawv siv los tsim cov teeb. Cov ntaub ntawv uas xaiv tau feem ntau yog cov npe hauv qab thiab cov kab ua ke, uas siv los ua cov ntawv sau rau hauv daim phiaj.

1. Sau cov ntaub ntawv uas tau muab teev rau hauv daim duab saum toj no rau hauv cov nplooj ntawv ua haujlwm tseeb.
2. Thaum nkag, qhia ntau txog cov hlwb ntawm A2 rau C6.

Thaum xaiv cov ntaub ntawv, lub npe thiab kab ntawv sab nrauv muaj nyob rau hauv kev xaiv, tab sis lub npe nyob rau sab saum toj ntawm cov ntaub ntawv cov lus tsis yog. Lub npe yuav tsum muab ntxiv rau lub teeb duab manually.

Tsim cov Kab Xev Taus

Cov kauj ruam nram qab no yuav tsim cov kab ntawv yooj yim - ib daim duab dawb, tsis meej - uas qhia txog cov ntaub ntawv xaiv cov kab thiab cov looj.

Tom qab ntawd, raws li tau hais, phau ntawv nthuav qhia yuav siv li cas los siv qee hom kev ntim ntau dua, uas yog ua raws, yuav hloov cov teeb theem pib phim cov kab teeb tshwm rau hauv thawj zawg ntawm qhov kev qhia no.

1. Nias rau ntawm daim ntxig ntawm daim ntawv sau.
2. Nyob hauv Cheeb Tsam Tshooj ntawm daim ntawv tais cai, nyem qhov Insert Line Chart icon los qhib cov ntawv teev npe ntawm cov qauv muaj / daim duab.
3. Hover koj tus pointer fav rau ib hom teeb duab los nyeem cov lus piav qhia ntawm daim duab.
4. Nias ntawm thawj kab 2-d kab kos hauv daim ntawv xaiv nws.
5. Cov kab ntawv sau yooj yim yog tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm raws li muaj nyob hauv daim duab ntawm tus swb ntxiv hauv qab.

Ua Qauv Qhia Cov Kab Tsa: Sau Daim Ntawv Qhia Chart

Kho kom raug lub npe Chart Title los txhaj rau nws ob zaug tab sis tsis txhob muab ob npaug rau

1. Nias ib zaug rau ntawm lub npe hu ua nws xaiv - ib lub thawv yuav tsum tshwm nyob ib ncig ntawm cov lus ntawm Daim Ntawv Chart.
2. Nyem ib zaug thib ob los muab cov Excel hloov kho hom , uas tso tus cursor hauv lub npov lub npe.
3. Rho tawm cov qauv ntawv siv lub Delete / Backspace tuav ntawm cov keyboard.
4. Sau lub npe ntawm daim ntawv qhia - Nruab Nrab Caij nplooj siab (hli) - hauv lub npov lub npe

Txhawm rau Tshooj Ib Feem ntawm Daim Ntawv Qhia

Muaj ntau ntau qhov sib txawv rau daim chart hauv Excel - xws li daim ntawv qhia npe thiab cov ntawv cim, thaj tsam thaj tsam uas muaj cov kab uas sawv cev rau cov ntaub ntawv xaiv, txoj kab thiab txoj kab ntsug, thiab kab rov tav.

Tag nrho cov seem no yog xam lwm yam khoom los ntawm qhov kev zov me nyuam, thiab, li ntawd, txhua tus tuaj yeem cais nyias. Koj qhia Excel uas yog ib feem ntawm cov teeb uas koj xav kom tau los ntawm kev txhaj tshuaj nrog tus pointer pointer xaiv nws.

Thaum lub caij nyeem ntawv no, yog tias koj cov qhabnias tsis zoo li cov teev tseg, nws yog qhov zoo tshaj plaws uas koj tsis muaj feem ntawm txoj cai xaiv thaum koj ua ntawv thov kev xaiv.

Qhov feem ntau ua yuam kev yog txhaj rau thaj tsam ntawm thaj tsam ntawm lub teeb duab thaum lub hom phiaj yog los xaiv tag nrho cov teeb.

Qhov yooj yim tshaj los xaiv tag nrho cov teeb yog nias rau sab laug sab laug los yog sab xis ntawm lub npe ntawv.

Yog hais tias muaj qhov yuam kev, nws tuaj yeem kho sai siv Excel lub undo feature . Tom qab ntawd, nyem rau ntawm sab xis ntawm daim qauv thiab sim dua.

Hloov Lub Teeb Cov Xim Siv Cov Ntawv Cim Cov Tabs

Thaum ib daim duab / graph tsim nyob rau hauv Excel, los yog thaum twg ib qho teeb meem uas xaiv tau los ntawm txhaj rau nws, ob qho ntxiv tabs ntxiv rau qhov xov raws li pom hauv daim duab saum toj no.

Cov Chart Tools tab - Tsim thiab Hom Ntawv - muaj cov kev teeb tsa thiab kev xaiv teeb tsa tshwj xeeb rau cov kab kos, thiab lawv yuav siv rau hauv cov kauj ruam nram qab no los hloov cov keeb kwm yav dhau thiab cov xim ntawm daim duab.

Hloov Lub Teeb Cov Background xim

Rau qhov kev teeb duab tshwj xeeb no, formatting tom qab yog txheej txheem ob-kauj ruam vim hais tias gradient yog ntxiv los qhia me ntsis kev hloov xim xim ntawm horizontally hla lub teeb.

1. Nias ntawm tus keeb kwm yav dhau los xaiv tag nrho cov teeb.
2. Nyem ntawm Hom Ntawv ntawm cov ntawv sau.
3. Nias rau ntawm Daim Phiaj Xaiv, uas muaj nyob rau hauv daim duab saum toj no, qhib Daim Ntawv Xim Sau Ncauj Sau Ntawv.
4. Xaiv Dub, Cov Ntawv Sau 1, Ntaus 35% ntawm Chaws Xam Xeeb ntawm daim ntawv teev npe.
5. Nias rau ntawm Daim Phiaj Xaiv qhov thib ob zaug qhib lub Xim khawm tshuab raj.
6. Hover tus nas pointer dua Gradient xaiv nyob ze ntawm qab ntawm daim ntawv qhib lub Gradient vaj huam sib luag.
7. Hauv seem ntawm Qhov Tsaus Ntuj Variations ntawm lub vaj huam sib luag, nyem rau ntawm txoj kab laug sab laug mus ntxiv qhov gradient uas tau nce zuj zus ntawm sab laug mus rau sab xis ntawm lub teeb.

Hloov Cov Ntawv Xim

Tam sim no hais tias keeb kwm yav dhau dub, lub neej ntawd dub ntawv tsis pom dua. Qhov seem tom ntej no hloov cov xim ntawm txhua phau ntawv hauv daim duab kom dawb

1. Nias ntawm tus keeb kwm yav dhau los xaiv tag nrho cov teeb.
2. Nias qhov Hom Ntawv ntawm txoj kab yog tsim nyog.
3. Nias lub Nkoj Xov Xaiv kom qhib qhov Xaiv Cov Ntawv Xim kom sau.
4. Xaiv Dawb, Tom Qab 1 ntawm Xam Xim ntawm cov npe.
5. Tag nrho cov ntawv nyob hauv lub npe, x thiab y-axes, thiab lus dab neeg yuav tsum hloov mus dawb.

Hloov Cov Kab Xim: Ua Formatting nyob rau hauv Txoj Haujlwm Pane

Ob kauj ruam tom qab ntawm qhov kev nyeem ntawv siv qhov kev ua kom tiav , uas muaj feem ntau ntawm cov kev xaiv formatting rau cov kab kos.

Nyob hauv Excel 2013, thaum qhib txais, cov pane tshwm nyob rau ntawm sab tes xis ntawm daim Excel raws li muaj nyob hauv daim duab saum toj no. Cov nqe lus thiab cov hau kev xaiv hauv pane hloov nyob ntawm cheeb tsam ntawm daim ntawv teev lus xaiv tau.

Hloov cov kab xim rau Acapulco

1. Hauv daim phiaj, nyem ib zaug ntawm kab kab paj yeeb rau Acapulco los xaiv nws - me me tseem ceeb yuav tsum tshwm sim raws qhov ntev ntawm txoj kab.
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog.
3. Ntawm sab laug ntawm sab laug ntawm txoj kab, nyem rau ntawm Hom Kev Xaiv Ua Ntawv xaiv qhib Formatting Task pane .
4. Vim tias txoj kab rau Acapulco tau xaiv yav tas los, lub npe nyob rau hauv pane yuav tsum tau nyeem cov Ntawv Qhia Ntaus Ntawv.
5. Hauv pane, nyem rau ntawm Daim Piav Qhia icon (xim muaj peev xwm) qhib cov kab ntawv xaiv.
6. Nyob rau hauv daim ntawv teev cov kev xaiv, nias ntawm lub cim icon tom ntej ntawm daim ntawv lo Xim kom qhib lub Kab Xaiv tis npe.
7. Xaiv Green, Accent 6, Ntaus 40% ntawm Cheeb Tsam Xim ntawm daim ntawv - cov kab Acapulco yuav tsum hloov mus rau lub teeb xim ntsuab.

Hloov Amsterdam

1. Hauv daim duab, nyem ib zaug ntawm kab xiav rau Amsterdam los xaiv nws.
2. Nyob rau hauv daim Formatting ua hauj lwm pane, cov xim ntawm qhov tam sim no tso tawm hauv qab lub icon yuav tsum hloov ntawm ntsuab mus xiav uas qhia tias lub pane yog tam sim no displaying kev xaiv rau Amsterdam.
3. Nias ntawm lub cim icon qhib lub Kab Xaiv tis npe.
4. Xaiv Blue, Accent 1, Lighter 40% ntawm lub ntsiab xim xim ntawm daim ntawv - txoj kab rau Amsterdam yuav tsum hloov mus rau xim xiav xim.

Tso tawm ntawm cov Gridlines

Qhov sib tw dhau los hloov yog yuav kho cov kab sib chaws uas khiav los ntawm cov teeb.

Cov kab lus yooj yim muaj cov kab sib chaws no kom yooj yim nyeem cov nqi rau cov ntsiab lus tseem ceeb ntawm cov kab lus.

Lawv tsis ua, li cas los xij, yuav tsum tau ua kom pom tseeb heev. Ib txoj kev yooj yim rau lawv tuas yog los kho lawv daim ntawv siv cov Formatting Task pane.

Los ntawm kev ua neej tsis zoo, lawv cov qib kev sib npaug yog 0%, tabsis ua raws li hais tias, cov gridlines yuav ploj mus rau hauv keeb kwm yav dhau uas lawv muaj.

1. Nias rau Hom Kev Xaiv Ua Hom rau ntawm Hom Ntawv Tab sis yog tsim nyog qhib lub Formatting Task pane
2. Hauv daim phiaj, nyem ib zaug ntawm 150 hli gridline khiav hauv nruab nrab ntawm lub teeb - tag nrho cov phiaj xwm sab nraud yuav tsum muaj kev pom tseeb (xiav dots tom kawg ntawm txhua daim phiaj)
3. Hauv pane hloov cov theem ntawm daim npog rau 75% - cov qauv ntawm daim phiaj yuav tsum ploj mus