Yuav Ua Li Cas thiab Ua Kom Ib Daim Ntawv Qhia Kem hauv Excel 2010

01 ntawm 06

Cov kauj ruam los ua Daim Ntawv Qhia Kem hauv Excel 2010

Cov kauj ruam los tsim ib daim ntawv sau qhia yooj yim hauv Excel 2010 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 daim ntawv qhia yam khoom;

Ib daim ntawv dawb, unformatted - uas tsuas qhia cov lus xaiv ntawm cov ntaub ntawv, ib zaj lus dab neeg, thiab qhov tseem ceeb ntawm lub cev - 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 2010 thiab 2007. Cov no txawv ntawm cov neeg muaj nyob rau thaum ntxov thiab tom qab versions ntawm qhov kev zov me nyuam. Siv cov kev txuas mus ntxiv nram qab no rau cov ntawv qhia kev qhia ntawv rau lwm cov qauv ntawm Excel.

• Excel 2013 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 li ntawd, cia li xaiv cov xim rau koj cov kev nyiam xws li hloov chaw thiab nqa mus.

• Npaum li cas thiab pauv cov ntsiab lus tseem ceeb hauv phau ntawv no

02 ntawm 06

Tsim Tsa Zauv Suab Sau Hauv Excel

Nkag Mus thiab Xaiv Cov Ntaub Ntawv Qhia Tawm

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.

Thawj kauj ruam hauv kev tsim ib daim ntawv qhia yeej ib txwm nkag mus rau hauv cov ntawv qhia - tsis muaj teeb meem li cas ntawm cov ntawv qhia tau tsim.

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

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 daim phiaj qhia tawm.

1. Sau cov ntaub ntawv uas tau muab teev rau hauv daim duab saum toj no rau hauv cov nplooj ntawv ua haujlwm
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

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 3-D Clustered Kem seem ntawm daim ntawv, nyem rau Clustered Kem - ntxiv rau daim ntawv sau qhia no rau ntawm daim ntawv ua haujlwm

03 ntawm 06

Excel daim ntawv thiab Tshem tawm Gridlines

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.

Muab cov Gridlines los ntawm thaj chaw hauv thaj chaw

Cov kab lus yooj yim muaj cov kab sib chaws uas khiav los ntawm cov kab hauv thaj av los ua kom yooj yim nyeem cov kev cai rau cov ntsiab lus ntawm cov ntsiab lus - tshwj xeeb hauv cov kab kos uas muaj cov ntaub ntawv ntau heev.

Txij li tsuas muaj peb series ntawm cov ntaub ntawv nyob rau hauv daim ntawv qhia no, cov ntsiab lus ntawm cov ntaub ntawv tseem ceeb nyeem, yog li cov kab sib chaws tau ua tas lawm.

1. Hauv daim phiaj, nyem ib zaug ntawm $ 60,000 gridline khiav hauv nruab nrab ntawm lub teeb mus rau tag nrho cov duab sab nrauv - me me voj voog yuav tsum pom thaum kawg ntawm txhua daim phiaj
2. Nias qhov rho tawm qhov tseem ceeb ntawm cov keyboard kom tshem tawm cov gridlines

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

04 ntawm 06

Hloov Cov Ntawv Teev Tseg

Cov Ntawv Sib Ceeb Cov Tabs

Thaum twg ib daim ntawv teev lus hauv Excel 2007 lossis 2010, lossis thaum twg ib daim ntawv xaiv ntsej xaiv tau los ntawm txhaj rau nws, peb daim ntxiv rau ntxiv raws li tau hais hauv daim duab saum toj no.

Cov Chart Tools tab - Tsim, Layout, 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 ntxiv ib lub npe rau daim ntawv qhia kab ntawv thiab hloov xim cov ntawv qhia.

Ntxiv thiab Kho Cov Ntawv Qhia Chart

Hauv Excel 2007 thiab 2010, cov kab kos theem pib tsis muaj cov ntawv qhia lub npe. Cov no yuav tsum muab qee yam ntxiv siv Chart Title xaiv nyob ntawm Layout tab thiab mam li kho kom pom lub npe yam.

1. Nyem ib zaug ntawm daim ntawv xaiv los xaiv nws, yog tias tsim nyog, ntxiv cov ntawv qhia cov cuab yeej tabs rau txoj kab
2. Nias ntawm Layout tab
3. Nias ntawm Daim Ntawv Qhia ntawm Chart los qhib lub npe ntawm cov kev xaiv
4. Xaiv Daim Ntawv Daws Tawm los ntawm daim ntawv teev npe rau lub thev tso rau lub npe ntawm lub thawv ntawv nyob rau hauv daim ntawv tshaj tawm cov kab lus saum toj
5. Nyem ib zaug hauv lub npov lub npe kom thiaj li hloov lub ntsiab lus ntawm lub npe ntawv
6. Rho tawm cov ntawv cim tseg thiab nkag mus rau hauv daim ntawv qhia npe - Cov Khw Muag Khoom Khw 2013 Cov Nyiaj Khwv Tau Tshaj Tawm - rau hauv lub thawv npe
7. 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

Hloov Cov Qauv Hom

Hloov cov hom ntaus ntawv siv los ntawm lub neej nyob rau tag nrho cov ntawv nyeem hauv daim duab yuav tsis tsuas yog txhim kho cov qauv ntawm daim duab, tab sis nws tseem yuav ua rau nws yooj yim nyeem cov lus dab neeg thiab cov npe thiab qhov tseem ceeb.

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 nias rau ntawm daim font Arial Dub nyob rau hauv daim ntawv sau hloov lub npe rau daim ntawv no

Hloov Cov Lus Cog Tseg thiab Axes

1. Rov ua li cov kauj ruam saum toj los hloov cov ntawv nyob hauv daim ntawv cov lus dab neeg thiab X thiab Y looj rau Arial Dub

05 ntawm 06

Hloov Xim nyob hauv Daim Ntawv Qhia Kem

Hloov Xim Ntawm Pem Hauv Ntej thiab Sab Phab Ntsa

Cov kauj ruam hauv kev nyeem ntawv no yuav hloov cov xim ntawm daim duab sab nrauv thiab sab phab ntsa kom dub raws li pom hauv daim duab saum toj no.

• Hauv pem teb sab qauv yog cov duab plaub sab tav nyob hauv qab cov lus qhia hauv thaj tsam ntawm thaj chaw.
• Sab phab ntsa yog nyob rau ntawm sab laug sab ntawm thaj tsam thaj tsam ntawm cov ntaub ntawv kab thiab daim ntawv lo Y (ntsug) axis.

Ob qho tag nrho cov khoom yuav raug xaiv los siv cov ntawv qhia ntsej muag sau rau ntawm sab laug ntawm Layout tab ntawm txoj kab.

1. Nias ntawm daim duab qhia tom qab xaiv tag nrho cov ntawv qhia yog tsim nyog
2. Nias ntawm Layout tab ntawm txoj kab
3. Nrog rau tag nrho daim ntawv xaiv xaiv, daim ntawv teev cov ntawv sau yuav tsum tso saib Chart Area nyob rau sab saum toj ntawm sab laug ntawm txoj kab.
4. Nias ntawm qhov xub hauv qab ntawm daim ntawv xaiv ntsiab lus xaiv qhib lub npe ntawm daim ntawv tso npe
5. Xaiv Pem Hauv Ntej los ntawm daim ntawv teev cov ntu ntawv los piav txog hauv pem teb
6. Nias rau ntawm Hom ntawv ntawm daim qauv
7. Nias rau ntawm Daim Phiaj Xaiv kom qhib qhov Filling Colors drop down panel
8. Xaiv Dub, Phau Ntawv 1 ntawm Xam Xim Xim ntawm lub vaj huam sib luag los hloov daim qauv duab xim xim dub
9. Rov ua li cov kauj ruam 2 mus rau 6 sab sauv kom hloov xim ntawm daim duab Sab Phab Ntsa kom dub

Yog tias koj tau ua raws li tag nrho cov kauj ruam hauv kev nyeem, ntawm qhov no, koj daim ntawv yuav tsum thooj li tus pom hauv daim duab saum toj no.

06 ntawm 06

Hloov Colours Xim thiab Tsav Daim Ntawv Cheeb Tsam

Hloov cov xim ntawm Daim Qhia Cov Ntaub Ntawv Txhua

Cov kauj ruam hauv kev nyeem ntawv pauv cov tsos ntawm cov ntaub ntawv txhua qhov hloov xim, ntxiv qhov gradient, thiab ntxiv ib qho kev qhia rau txhua kem.

Cov qauv sau thiab cov qauv kev xaiv ua qauv , uas nyob rau ntawm Hom Ntawv yuav raug siv los cuam tshuam txog cov kev hloov no. Cov qhab-nees yuav phim rau txhua kab pom hauv daim duab saum toj no.

Hloov Cov Nyiaj Them Tag Nrho Cov Nyiaj Tag Nrho

1. Nyem ib zaug rau ntawm ib qho ntawm cov nyiaj xiav tag nrho hauv daim ntawv xaiv tsa los xaiv tag nrho peb qho xim xiav
2. Nias rau ntawm Hom Txheej ntawm txoj kab yog tsim nyog
3. Nias rau ntawm Daim Phiaj Xaiv kom qhib qhov Filling Colors drop down panel
4. Xaiv maub xiav, Ntawv nyeem 2, Ntaus 60% ntawm lub ntsiab xim xim ntawm lub vaj huam sib luag los hloov cov xim txhua xim

Ntxiv Gradient

1. Nrog tag nrho cov Nyiaj Ceg Tag Nrho los mus xaiv, nias rau ntawm Poob Poob xaiv dua zaum ob los qhib lub Xim Sau cov xim
2. Hover tus nas pointer dua Gradient xaiv nyob ze ntawm qab ntawm daim ntawv qhib lub Gradient vaj huam sib luag
3. Nyob rau hauv seem Kev Sib Hlis ntawm lub vaj huam sib luag, nias rau ntawm Txoj Kev Tawm Tsav Xwm kom ntxiv qhov sib thooj uas tau txais los ntawm sab laug mus rau sab xis ntawm sab xis

Muab Daim Ntawv Teev Npe Ntxiv

1. Nrog rau Tag Nrho Cov Nyiaj Khwv tau los tseem xaiv, nyem rau ntawm Kev Txhim Kho Xov Tooj los qhib cov Ntawv Qhia Tawm Tsam Ntawv Tshaj Tawm
2. Nyob hauv Cheeb Tsam Xim ntawm lub vaj huam sib luag, xaiv Xia Xia ntxiv rau ib kab xiav xiav rau txhua kem
3. Nias ntawm qhov Kev Txhim Kho Xov Tooj thib ob
4. Nias rau ntawm Qhov Kev Lom Zem hauv cov zaub mov kom qhib tau ib lub tshuab raj me me
5. Xaiv 1 1/2 pt. kom ua rau kom qhov thickness ntawm txhua kab 'qauv

Sau Tus Qauv Siv Nyiaj Tag Nrho

Rov ua dua cov kauj ruam uas siv los ua cov qauv Total Revenue , siv cov nram qab no:

• Kem Sau Pleev Xim: Red Accent 2, Darker 50%
• Gradient: Teeb Variations , Tawm Txoj Cai
• Colour Nthuav Qhia Xim: Liab Tsav Tsheb 2, Tsaus Tawv 50%
• Daim Ntawv Teev Npe Kab Laj: 1 1/2 pt.

Sau cov Nyiaj Tau Los / Cov Ncua Lossis

Rov ua dua cov kauj ruam uas siv los ua cov qauv Total Revenue , siv cov nram qab no:

• Kem Puv Xim: Txiv Neej Ntsib Hlis 3, Darker 25%
• Gradient: Teeb Variations , Tawm Txoj Cai
• Daim Ntawv Qhia Teeb Meem: Txiv Plig Xim Tus Hlis 3, Darker 50%
• Daim Ntawv Teev Npe Kab Laj: 1 1/2 pt.

Txij ntawm no mus, yog tag nrho cov txheej txheem formatting tau ua raws, daim ntawv qhia kab ntawv yuav tsum zoo li daim phiaj pom hauv daim duab saum toj no.

Tsiv Daim Ntawv Cheeb Tsam rau Daim Ntawv Xaiv Tshwj Xeeb

Kauj ruam kawg ntawm qhov kev nyeem tau txav cov ntawv qhia rau lwm daim ntawv hauv phau ntawv siv cov Move Chart dialog box.

Tsav ib daim ntawv rau ib daim ntawv yuav ua rau nws yooj yim dua los luam cov ntawv qhia thiab nws tseem tuaj yeem pab kom tsis muaj teeb meem hauv daim ntawv ua haujlwm loj.

1. Nias ntawm daim ntawv qhia keeb kwm yav dhau los xaiv tag nrho cov ntawv qhia
2. Nias ntawm qhov Tsim tsim ntawm txoj xov
3. Nias rau ntawm Daim Ntawv Qhia Txav Mus Rau Sab Nraud ntawm Sab Laum Txoj Cai ntawm Txoj Cai Rau Kev Tshawb Fawm Mus Ncauj Lus
4. Raws li tau hais hauv daim duab saum toj no, nyem rau ntawm Daim Ntawv Xaiv Tshiab nyob rau hauv lub thawv sab nraud thiab - optionally - muab cov ntawv npe, xws li Khw Khw 2013 Cov Nyiaj Khwv Tau Los
5. Nias qhov sau kom kaw lub thawv ntawv - daim ntawv yuav tsum muaj nyob rau ntawm ib daim ntawv nrog lwm lub npe tshiab rau ntawm daim ntawv nyob hauv qab ntawm qhov screen.