Yuav Tsim Ib Daim Ntawv Qhia Sab Hauv Excel

01 ntawm 06

Yuav Tsim Ib Daim Ntawv Qhia Sab Hauv Excel

Cov kauj ruam los tsim ib qho qauv qhia ntawv hauv Excel yog:

1. Tshawb cov ntaub ntawv muab tso rau hauv daim ntawv qhia - suav nrog cov kab ntawv thiab kab ntawv sab nraud tab sis tsis yog lub npe rau cov lus qhia;
2. Nias rau ntawm Insert tab ntawm txoj kab ;
3. Hauv daim npav kab ntawv ntawm txoj kab, nyem rau Daim Ntawv Qhia Sab Nraud Chart icon qhib lub npe ntawm cov ntawv muaj nyob hauv cov ntawv;
4. Hover koj tus pointer nas hla ib hom ntawv coj los nyeem cov lus piav qhia ntawm daim phiaj xwm;
5. Nias ntawm qhov teeb meem;

Ib daim ntawv dawb, unformatted - ib qho uas qhia tsuas yog txhua kab uas sawv cev ntawm cov lus 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 hauv Excel

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 ntawv qhia kev qhia ntawv rau lwm cov qauv ntawm Excel.

• Excel 2010 Kem Daim Ntawv Qhia
• Excel 2003 (thiab ua ntej versions) Kem Qhia Ntawv

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.

Lub ntsiab lus siv rau qhov kev qhia no yog lub Office Office ntsiab.

Yog tias koj siv lwm lub ntsiab lus thaum ua raws li qhov kev qhia no, cov xim uas teev rau hauv cov kauj ruam kev qhia kuj yuav tsis muaj nyob rau hauv lub ntsiab lus uas koj siv. Yog hais tias tsis yog, cia li xaiv cov xim rau koj li kev hloov chaw thiab kev ua haujlwm.

02 ntawm 06

Nkag Mus Siv Cov Ntaub Ntawv Cov Ntaub Ntawv thiab Tsim Tsab Ntawv Qhia Npe

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 hauv cov ntawv qhia cov ntaub ntawv yeej yog thawj kauj ruam hauv kev tsim cov ntawv qhia - tsis muaj teeb meem dab tsi ntawm cov ntawv sau.

Cov kauj ruam thib ob yog qhov tseem ceeb ntawm cov ntaub ntawv siv los tsim cov ntawv qhia.

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 D5 - qhov no yog qhov ntau ntawm cov ntaub ntawv uas yuav muaj npe los ntawm daim ntawv qhia kab ntawv

Tsim Tsa Sau Npe Sau

Cov kauj ruam hauv qab no yuav tsim ib daim ntawv sau qhia yooj yim - ib daim ntawv dawb, tsis muaj qauv - uas qhia txog peb cov ntaub ntawv, cov lus dab neeg, thiab lub npe ntawv pov thawj.

Tom qab ntawd, raws li tau hais lawm, phau ntawv nthuav qhia yuav ua li cas siv qee cov qauv ntau dua, uas yog ua raws li, yuav hloov qhov kev teeb tsa kom yooj yim kom haum raws li pom nyob rau saum toj kawg nkaus ntawm phau ntawv no.

1. Nias rau ntawm daim ntxig ntawm daim ntawv sau
2. Nyob hauv lub thawv ntawv ntawm txoj kab, nyem rau ntawm Daim Qhia Sab Nruab Nrab Cheeb Tswm sim qhib qhov sau npe ntawm cov hom ntawv muaj
3. Hover koj tus pointer nas hla ib hom ntawv coj los nyeem cov lus piav qhia ntawm daim phiaj
4. Hauv seem 2-D Sab seem ntawm daim ntawv, nyem rau Clustered Kem - ntxiv rau daim ntawv sau qhia no rau ntawm daim ntawv khomob

03 ntawm 06

Muab Daim Ntawv Chart Ntxiv

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. Nkag mus rau lub npe ntawm daim ntawv sau npe - Khw Khw 2013 Cov Nyiaj Khwv Tau Tshaj Tawm - rau hauv lub npov lub npe
5. Muab tus cursor ntawm Kav thiab 2013 nyob rau hauv lub npe thiab nias tus Sau yuam rau ntawm cov keyboard kom cais lub npe mus rau ob kab

Nyob rau ntawm no, koj daim duab yuav tsum zoo li tus qauv uas tau pom hauv daim duab saum toj no.

Txhawm rau Tshooj Ib Feem ntawm Daim Ntawv Qhia

Muaj ntau ntau qhov sib txawv rau daim chart hauv Excel - xws li daim duab thaj chaw uas muaj cov qauv ntawv qhia sawv cev rau cov kab lus xaiv, cov lus dab neeg, thiab daim ntawv qhia lub npe.

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 rau Excel uas yog ib feem ntawm daim duab uas koj xav kom tau los ntawm kev txhaj tshuaj nrog tus pointer pointer.

Hauv cov kauj ruam nram qab no, yog tias koj cov qhabnias tsis zoo li cov teev nyob rau hauv kev nyeem, nws yuav yog qhov koj tsis muaj feem ntawm txoj cai xaiv thaum koj ntxiv qhov kev xaiv cov kev xaiv.

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

Qhov yoojyim tshaj los xaiv tag nrho cov ntawv qhia yog mus nyem rau ntawm 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 tus Excel lub undo feature kom tshem tawm qhov yuam kev. Tom qab ntawd, nyem rau ntawm sab xis ntawm daim qauv thiab sim dua.

04 ntawm 06

Hloov Cov Daim Ntawv Teev Tseg thiab Kem Xim

Cov Ntawv Sib Ceeb Cov Tabs

Thaum ib daim ntawv teev lus hauv Excel, lossis thaum twg ib daim ntawv xaiv ntsej xaiv raug xaiv 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 qhov tshwj xeeb rau cov kab kos, thiab lawv yuav raug siv nyob rau hauv cov kauj ruam nram qab no los teeb rau ntawm daim ntawv qhia kem.

Hloov Cov Daim Ntawv Qhia Chart

Daim ntawv qhia yeej muaj ob peb yam kev sib txuas ntawm kev xaiv hom uas siv tau kom ceev tau ib qho qauv siv ntau yam kev xaiv.

Los yog, raws li yog hauv cov ntaub ntawv hauv qhov kev nyeem no, lawv tuaj yeem siv los ua ib qho pib taw qhia rau kev teeb tsa nrog cov kev hloov ntxiv rau cov qauv uas raug xaiv.

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho cov ntawv qhia
2. Nias ntawm qhov Tsim tsim ntawm txoj xov
3. Nias rau ntawm Style 3 kev xaiv nyob hauv Chart Styles section ntawm txoj cai
4. Tag nrho cov kab hauv daim duab yuav tsum muaj luv, dawb, kab tav toj khiav los ntawm lawv thiab cov lus dab neeg yuav tsum txav mus rau sab saum toj ntawm daim phiaj hauv qab lub npe

Hloov lub Xim Xim

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho cov ntawv qhia yog tsim nyog
2. Nias rau Qhov Hloov Xim Xaiv nyob rau ntawm sab laug sab ntawm Tus Tsim Tsim ntawm txoj hlua qhib ib lub cim npe ntawm cov xim xaiv
3. Hover koj tus nas pointer dua txhua kab ntawm cov xim kom pom lub npe xaiv
4. Nias ntawm Colour 3 xaiv nyob rau hauv daim ntawv - qhov thib peb xaiv nyob rau hauv cov yeeb yuj ntawm daim ntawv
5. Cov xim xim rau txhua kab yuav tsum hloov rau txiv kab ntxwv, daj, thiab ntsuab, tab sis cov kab dawb yuav tsum tuaj yeem nyob hauv txhua kem

Hloov Cov Daim Ntawv Cheeb Tsam Xim

Cov kauj ruam no hloov cov keeb kwm ntawm daim duab kom pom qhov muag grey uas yog siv Daim Phiaj Xaiv nyob rau hauv Hom Ntawv ntawm cov kab ntawv txheeb hauv cov duab saum toj no.

1. Nias ntawm tus keeb kwm yav dhau los xaiv tag nrho cov ntawv qhia thiab tso saib Chart Tool tabs ntawm daim ntawv sau
2. Nias rau ntawm Hom ntawv
3. Nias rau ntawm Daim Phiaj Xaiv kom qhib qhov Filling Colors drop down panel
4. Xaiv Grey -50%, Accent 3, Lighter 40% ntawm lub ntsiab xim xim ntawm lub vaj huam sib luag los hloov daim phiaj xim keeb kwm yav dhau mus rau lub teeb grey

05 ntawm 06

Hloov Cov Ntawv Teev Tseg

Hloov Cov Ntawv Xim

Tam sim no hais tias keeb kwm yav dhau yog grey, lub neej ntawd dub ntawv tsis pom heev. Qhov seem tom ntej no hloov cov xim ntawm txhua phau ntawv hauv daim phiaj qhia rau ntsuab kom zoo qhov sib txawv ntawm ob qhov kev siv Cov Ntawv Sau .

Cov kev xaiv no yog nyob rau ntawm Hom Ntawv Tab ntawm tus qauv uas tau txheeb tseg hauv daim duab nyob rau nplooj ntawv dhau los ntawm kev nyeem.

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho daim phiaj qhia ntawv, yog tias tsim nyog
2. Nias rau ntawm Hom ntawv ntawm daim qauv
3. Nias rau ntawm Txoj Kev Xaiv Sau los qhib cov Ntawv Xim Sau Ncauj Lus
4. Xaiv Green, Accent 6, Darker 25% ntawm lub ntsiab xim ntawm daim ntawv
5. Tag nrho cov ntawv sau rau hauv lub npe, kab xev, thiab cov lus dab neeg yuav tsum hloov mus rau ntsuab

Hloov Cov Qauv Hom, Qhov Coj, thiab Qhov Tseem Ceeb

Hloov qhov loj thiab hom ntawv siv rau tag nrho cov ntawv nyob rau hauv daim ntawv qhia, yuav tsis tsuas yog kev txhim kho dua li cov ntawv siv font, tab sis nws tseem yuav ua kom nws nyeem cov lus dab neeg thiab cov nqe lus hauv cov ntawv qhia yooj yim. Bold formatting tseem yuav ntxiv rau cov ntawv nyeem kom nws sawv tawm ntau tshaj rau tom qab.

Cov kev hloov no yuav raug ua kom siv cov kev xaiv nyob rau hauv seem ntawm daim ntawv ntawm Tsev Tsev ntawm txoj kab.

Lus Cim : Qhov luaj li cas ntawm cov font yog ntsuas nyob rau hauv cov ntsiab lus - feem ntau luv rau pt .
72 pt. ntawv yog sib npaug rau ib nti - 2.5 cm - loj.

Hloov daim ntawv Chart Title Text

1. Nyem ib zaug hauv daim ntawv qhia lub npe xaiv nws
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nyob rau hauv seem ntawm cov ntawv sau ntawm txoj kab, nyem rau ntawm Lub Thawv Sau ntawv kom qhib lub npe ntawm cov ntawv sau muaj
4. Tshem mus nrhiav thiab nyem rau ntawm font Leelawadee hauv daim ntawv teev cov npe ntawm cov ntawv no
5. Nyob rau hauv lub thawv ntawv loj ntawm lub npov ntawm lub thawv ntawv, teem lub npe ntawv loj rau 16 pt.
6. Nias ntawm tus npau suav icon (Tsab Ntawv B ) hauv qab Kem Thaj los ntxiv rau hom ntawv sau ntawv

Hloov Cov Lus Cog Tseg thiab Axes

1. Nyem ib zaug ntawm X axis (kab rov tav) cov ntawv hauv cov ntawv xaiv los xaiv cov npe khoom qab zib
2. Siv cov kauj ruam teev tseg saum toj no hloov cov ntawv nyeem, sau cov ntawv lo no rau 10 pt Leelawadee, bold
3. Nyem ib zaug ntawm daim ntawv Y xaj (ntsug) hauv daim phiaj xwm xaiv qhov nyiaj npaum li cas ntawm sab sab ntawm daim qauv
4. Siv cov kauj ruam saum toj no, muab cov ntawv lo no rau 10 pt Leelawadee, bold
5. Nyem ib zaug ntawm daim ntawv qhia cov lus dab neeg los xaiv nws
6. Siv cov kauj ruam saum toj no, teev cov lus dab neeg rau 10 pt Leelawadee, bold

Tag nrho cov ntawv hauv daim duab yuav tsum yog tam sim no yog Leelawadee font thiab tsaus ntsuab hauv xim. Nyob rau ntawm lub sij hawm no, koj daim duab yuav tsum zoo li daim duab hauv daim duab saum toj no.

06 ntawm 06

Ntxiv Gridlines thiab Hloov Lawv Xim

Txawm tias cov kab sib chaws kab rov tav twb pib nrog lub neej nyob rau hauv daim ntawv qhia, lawv tsis yog ib feem ntawm tus qauv tsim tshiab uas tau xaiv nyob hauv kauj ruam 3, thiab, yog li ntawd, muab tshem tawm.

Cov kauj ruam no yuav ntxiv cov phiaj xwm rov qab rau hauv thaj tsam ntawm daim duab.

Thaum tsis muaj ntaub ntawv cov ntawv qhia txog tus nqi ntawm txhua kem, gridlines ua kom yooj yim nyeem cov kem ntawm qhov txiaj uas teev nyob rau ntawm txoj kab Y (ntsug).

Cov phiaj xwm sab nraud ntxiv ntxiv uas siv Daim Ntawv Qhia Ntxiv Cheeb Tsam rau ntawm Tus Tsim Kev Tsim ntawm cov ntawv sau.

1. Nyem ib zaug ntawm ib qho ntawm daim duab thaj tsam ntawm daim ntawv xaiv tsa los xaiv nws
2. Nias ntawm qhov Tsim tsim ntawm txoj kab yog tsim nyog
3. Nias rau ntawm Daim Ntawv Qhia Ntxiv Chapters ntawm sab laug ntawm txoj hlua qhib lub tshuab raj tawm
4. Hauv daim ntawv qhia zaub mov nram qab no, nyem rau ntawm Gridlines> Qib Qib Siab Qib Siab ntxiv rau kev faint, dawb, gridlines rau thaj tsam ntawm daim duab

Kev Sau Ntaus Hloov Siv Cov Qauv Ua Pag Ua Piav Qhia

Cov kauj ruam tom ntej ntawm kev nyeem ntawv yuav siv cov formatting pane , 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.

Thawj kauj ruam yuav hloov cov xim ntawm cov kab sib chaws li tsuas tau ntxiv saum dawb los ntawm txiv kab ntxwv thiaj li ua rau lawv pom dua tiv thaiv grey rov tom qab ntawm thaj tsam ntawm daim duab.

Hloov cov Gridlines 'xim

1. Hauv daim phiaj, nyem ib zaug ntawm $ 60,000 gridline khiav hauv nruab nrab ntawm lub teeb - tag nrho cov kab sib chaws yuav tsum tau muab teev kom meej (xiav thiab dawb dots tom kawg ntawm txhua daim phiaj)
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog
3. Nias ntawm Hom Kev Xaiv Kev Txheeb rau ntawm sab laug ntawm txoj kab ntawv qhib lub Formatting Task pane - lub npe ntawm sab saum toj lub pane yuav tsum yog Hom Kev Loj Hlob
4. Hauv kab poom, teem caij hom kab mus rau kab
5. Teem cov xim gridline rau Orange, Accent 2, Darker 25%
6. Tag nrho cov kab sib chaws hauv thaj tsam ntawm thaj chaw yuav tsum hloov rau xim liab tsaus nti

Sau lub npe ntawm X axis

X axis kab yog nyob saum toj no X axis cov ntawv (cookie npe), tab sis, zoo li cov kab sab nrauv, nws tsis yooj yim pom vim qhov grey background ntawm daim duab. Cov kauj ruam no yuav hloov cov xim xaj thiab kab tuab kom sib npaug raws li cov qauv ntawm daim ntawv teev lus.

1. Nias ntawm X axis lo ntsiab lus kom pom cov kab X Xeeb
2. Hauv kev ua hauj lwm cov txheej txheem, raws li muaj nyob hauv daim duab saum toj no, teem caij hom kab mus rau kab
3. Teem txoj kab xev xaim rau txiv kab ntxwv, Hloov 2, Tsaus dua 25%
4. Teem txoj kab dav dav dav mus rau 0.75 pt.
5. Txoj kab X-xais yuav tsum tam sim no phim daim phiaj duab gridlines

Yog tias koj tau ua raws li tag nrho cov kauj ruam hauv qhov kev qhia no, koj daim ntawv qhia kab ntawv yuav tsum tam sim no phim tus piv txwv tso tawm rau sab saum toj ntawm nplooj ntawv no.