Muab Hom Chart Hom Nyob Hauv Excel 2010

01 ntawm 09

Ntxiv ib qho Y A Secondary Y Axis rau Daim Npav Piav Qhia

Lus Cim : Cov kauj ruam teev hauv cov ntawv nyeem no tsuas siv tau rau versions of Excel txog rau thiab nrog rau Excel 2010 .

Excel cia koj muab ob los sis ntau daim duab los sis ntau yam sib txawv los ua kom yooj yim rau cov ntaub ntawv qhia ua ke.

Ib txoj hauv kev yooj yim los ua kom tiav txoj hauj lwm no yog los ntawm kev ntxiv qhov ntsug thib ob los yog Y axis rau sab xis ntawm daim phiaj. Ob pawg ntawm cov ntaub ntawv tseem qhia ib qho X lossis kab rov tav ntawm sab hauv qab ntawm daim duab.

Los ntawm xaiv hom kev qhia dawb dawb - xws li daim ntawv qhia kab ntawv thiab kab teeb - qhov kev nthuav qhia ntawm ob cov ntawv teev lus qhia yuav kho kom zoo.

Cov kev siv rau hom kev qhia ua ke no yog suav cov qauv nruab nrab ntawm cov hli thiab cov lus xaus los ua ke, tsim cov ntaub ntawv xws li cov khoom tsim tawm thiab cov nqi tsim, los sis txhua hli muag thiab tus nqi muag txhua hli.

Daim Ntawv Qhia Ua Raws Ua Qauv

• Ib qho uas yuav tsum tau muaj rau cov ntaub ntawv tau muab tso tawm yog tias nws yuav tsum faib cov X axis (kab rov tav) qhov tseem ceeb - xws li lub sijhawm los sis qhov chaw.
• Tsis tas li, tsis yog txhua hom ntawv qhia tau ua ke. 3-D kab kos, piv txwv, tsis tuaj yeem koom nrog hauv daim ntawv qhia ua ke.

Cim Ua Qauv Kev Ntsuam Xyuas Hauv Xyoo

Qhov kev qhia no yog siv cov txheej txheem tsim nyog rau kev sib txuas ua kab thiab kab kab ua ke los tsim ib qho kev nyab xeeb lossis cov cim climatograph , uas qhia qhov nruab nrab hli thiab qhov kub thiab txias ntawm qhov chaw.

Raws li muaj nyob hauv daim duab saum toj no, daim duab qhia sab nraud, lossis daim duab thaij, qhia qhov nruab nrab txhua hli thaum cov kab teeb qhia txog qhov ntsuas qhov nruab nrab.

Cov Kauj Ruam Tutorial

Cov kauj ruam ua raws li hauv kev qhia kom tsim cov qauv kev nyab xeeb yog:

1. Tsim muaj ob txoj kab ntawv qhia ob sab, uas qhia txog cov nag lossis daus thiab cov ntaub ntawv hauv cov xim sib txawv
2. Hloov hom ntawv qhia rau qhov ntsuas kub ntawm txhua kab mus rau kab
3. Tshem cov ntsiab lus kub ntawm qhov xub thawj ntawm txoj kab (sab laug sab ntawm daim qauv qhia) mus rau theem nrab sab xis (sab xis ntawm daim qauv qhia)
4. Thov xaiv cov kev xaiv rau cov cim kev nyab xeeb kom paub tias nws muab qhov teeb meem pom hauv daim duab saum toj no

02 ntawm 09

Nkag Mus thiab Xaiv Qhov Qhia Txog Kev Nyab Xeeb

Thawj kauj ruam hauv kev tsim cov qauv kev nyab xeeb yog nkag mus rau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .

Thaum cov ntaub ntawv nkag lawm, lub kauj ruam tom ntej yog xaiv cov ntaub ntawv uas yuav muab tso rau hauv daim phiaj.

Xaiv lossis highlighting cov ntaub ntawv qhia Excel qhia cov lus qhia hauv daim ntawv ua haujlwm kom muaj thiab tsis ua dab tsi.

Ntxiv nrog rau cov ntaub ntawv tus xov tooj, nco ntsoov xam tag nrho cov kem thiab kab npe uas piav txog cov ntaub ntawv.

Lus Cim: Qhov kev nyeem tsis suav nrog cov kauj ruam ntawm kev ua cov ntawv sau qhia raws li muaj nyob hauv daim duab saum toj no. Cov ntaub ntawv nyob rau hauv daim ntawv xaiv cov txheej txheem formatting options yog muaj nyob rau hauv no yooj yim excel formatting nyeem .

Cov Kauj Ruam Tutorial

1. Sau cov ntaub ntawv raws li pom hauv daim duab saum toj no rau hauv hlwb A1 rau C14.
2. Highlight hlwb A2 rau C14 - qhov no yog qhov ntau ntawm cov ntaub ntawv uas yuav muab tso rau hauv daim ntawv qhia

03 ntawm 09

Tsim Tsa Qhia Txog Daim Ntawv Sau Npe

Tag nrho cov kab kos yog pom nyob rau hauv Insert tab ntawm txoj cai nyob rau hauv Excel, thiab tag nrho qhia cov yam ntxwv no:

• Thaum tsim cov ntawv qhia hauv Excel, qhov kev zov me nyuam thawj zaug tsim dab tsi hu ua cov ntawv qhia yooj yim uas siv cov ntaub ntawv xaiv
• Hovering koj tus po po tias dhau ib daim ntawv qhia yuav coj los piav txog cov ntawv qhia
• Kev txhim kho ntawm ib pawg yuav qhib ib qho kev qhia txog txhua yam ntawm hom ntawv qhia uas muaj nyob hauv cov ntawv ntawd

Thawj kauj ruam hauv kev tsim muaj cov lus qhia ua ke - xws li ib qho qauv kev nyab xeeb - yog xav tau lub ntsiab lus ntawm tag nrho cov ntaub ntawv hauv ib hom ntawv qhia thiab hloov cov ntaub ntawv mus rau ib daim ntawv thib ob.

Raws li tau hais yav dhau los, rau qhov kev nyab xeeb ntawm kev nyab xeeb, peb yuav xub pom cov ntaub ntawv ntawm ib daim ntawv qhia kab raws li pom hauv daim duab saum toj no, thiab hloov daim ntawv sau qhia seb qhov ntsuas kub li cas.

Cov Kauj Ruam Tutorial

1. Nrog cov ntaub ntawv xaiv xaiv, nias ntawm Insert> Kem> 2-d Clustered Kem nyob rau hauv txoj kab
2. Daim ntawv sau qhia yooj yim, zoo ib yam li cov duab pom saum toj no, yuav tsum tsim thiab muab tso rau hauv daim ntawv ua haujlwm

04 ntawm 09

Hloov Cov Kub Txawv rau Cov Kab Xeem

Hloov cov hom ntawv hauv Excel yog siv cov Chart Type dialog box .

Txij li thaum peb xav hloov tsuas yog ib qho ntawm ob cov ntaub ntawv muab tso tawm rau ib hom ntawv sib txawv, peb yuav tsum tau qhia rau Excel uas yog ib qho.

Qhov no yuav ua tau los ntawm kev xaiv, los yog txhaj ib zaug, ntawm ib qho ntawm txhua daim duab, uas qhia txog txhua kab ntawm tib xim.

Kev xaiv rau kev qhib Chart Type dialog box muaj xws li:

• txhaj rau Daim Ntawv Qhia Ntaus Ntaus ntawm qhov Tsim Tsim ntawm Ribbon
• txoj cai txhaj rau ib qho ntawm txhua kab ntawv xaiv thiab xaiv Qhov Hloov Piv Txwv hom xaiv los ntawm txoj kev nco cia zaub mov

Tag nrho cov hom ntawv qhia muaj nyob hauv lub thawv txuas lus kom nws thiaj li hloov tau yooj yim los ntawm ib daim ntawv qhia mus rau lwm tus.

Cov Kauj Ruam Tutorial

1. Nyem ib zaug rau ib qho ntawm cov kub cov ntaub ntawv txhua - qhia nyob rau hauv xiav nyob rau hauv cov duab saum toj no - xaiv tag nrho cov xim ntawm cov xim nyob hauv daim ntawv
2. Hover nas pointer dua ib qho ntawm cov kab thiab txoj nyem nrog tus nas qhib lub ntsiab lus teb cov ntawv qhia zaub mov
3. Xaiv qhov Pauv Hloov Piv Txwv Hom xaiv los ntawm kev nco cia zaub mov qhib qhov Chart Type dialog box
4. Nias rau ntawm thawj kab kab kev xaiv nyob rau sab xis ntawm lub thawv sab nraud
5. Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
6. Nyob rau hauv daim phiaj, cov ntaub ntawv kub yuav tsum tam sim no muab tso tawm raws li kab xiav ntxiv rau txhua kab ntawm cov nag cov ntaub ntawv

05 ntawm 09

Tsiv cov ntaub ntawv mus rau Yary Nyab Yis

Kev hloov cov ntaub ntawv kub rau ib kab teeb meem yuav ua kom yooj yim kom paub qhov txawv nruab nrab ntawm ob cov ntawv teev, tab sis, vim hais tias nkawd ob qho tib si npaj rau tib lub voj voog , qhov kub thiab txias cov ntaub ntawv tau teev tseg raws li kab ncaj ncaj uas qhia peb me ntsis txog hli kub txawv.

Qhov no tau tshwm sim vim hais tias ntawm qhov teev ntawm ib lub voj voog qaum yog sim kom haum raws li ob cov ntaub ntawv teev uas sib txawv heev hauv qhov siab.

Qhov nruab nrab kub cov ntaub ntawv rau Acapulco tsuas muaj me me ntawm 26.8 rau 28,7 degrees Celsius, thaum cov lus qhia los nag lossis daus txawv ntawm tsawg tshaj li 3 millimeters hauv lub Peb Hlis Ntuj kom dhau 300 hli hauv lub Cuaj Hli.

Hauv kev teev cov nplai ntawm txoj kab xaj los qhia txog ntau ntau ntawm cov nag cov ntaub ntawv, Excel tau tshem tawm ib qho kev hloov ntawm variation hauv cov ntaub ntawv kub txog lub xyoo.

Tsiv cov ntaub ntawv kub kub mus rau ib txoj kab xij ob sab - tshwm nyob ntawm sab xis ntawm daim ntawv qhia tau tso cai rau cais cais rau ob qhov kev qhia.

Yog li ntawd, cov ntawv qhia yuav nthuav tawm cov kev hloov ntawm ob qho tib si ntawm cov ntaub ntawv nyob rau tib lub sij hawm.

Tsiv cov ntaub ntawv kub kub mus rau ib theem siab ntsug thij ob yog ua tiav rau hauv Hom Ntawv Xaiv Cov Ntawv Sib Txuas Lus .

Cov Kauj Ruam Tutorial

1. Nyem ib zaug ntawm tus kab kub - pom tshwm liab hauv daim duab saum toj no - xaiv nws
2. Hover tus nas pointer hla txoj kab thiab txoj nyem nrog nas qhib lub ntsiab lus teb cov ntawv qhia zaub mov
3. Xaiv hom ntawv Xaiv Cov Ntawv Xaiv los ntawm txoj kev nco cia kom qhib lub Hom Phom Ntawv Qhia Tshaj Tawm

06 ntawm 09

Tsiv cov ntaub ntawv mus rau Yary Yis Qib (tsis yog)

Cov Kauj Ruam Tutorial

1. Nias rau ntawm Cov Kev Xaiv Fab Txhawb nyob rau hauv seem pauv ntawm lub thawv ntawv yog tias tsim nyog
2. Nias rau ntawm Optional Secondary Option nyob rau hauv txoj cai pane ntawm lub thawv ntawv qhia raws li muaj nyob hauv daim duab saum toj no
3. Nias lub khawm Kaw kaw lub thawv thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
4. Nyob rau hauv daim phiaj qhia, qhov teev rau cov ntaub ntawv kub yuav tsum tam sim no muab tso rau sab xis ntawm daim duab

Vim tias txav cov ntaub ntawv kub kub mus rau ob sab xis txoj kab, qhov qhia txog cov nag cov ntaub ntawv yuav tsum qhia ntau dua ntawm lub hli mus rau hli ua kom yooj yim pom qhov kub.

Qhov no tshwm sim vim hais tias qhov teev rau cov ntaub ntawv ntsuas kub ntawm txoj kab ntawm txoj kab ntawm sab xis ntawm daim duab tam sim no tsuas yog los npog ib chav muaj tsawg tshaj plaub degrees Celsius tsis dhau ib qho teev uas tau hloov ntawm zero ntawm 300 thaum cov lus ob teev sib koom ib teev.

Tshaj Tawm Ntawm Qhov Nruab Nrab

Nyob rau ntawm qhov no, qhov kev nyab xeeb ntawm daim duab yuav tsum zoo li cov duab pom nyob rau theem tom ntej ntawm kev nyeem.

Cov kauj ruam ntxiv nyob rau hauv phau ntawv nyeem qhia txog kev xaiv cov kev xaiv kom haum rau lub cim xeeb ua kom nws zoo li lub phiaj hauv kauj ruam ib.

07 ntawm 09

Tshaj Tawm Ntawm Qhov Nruab Nrab

Thaum nws tawm los rau cov kab kos rau hauv Excel koj tsis tas yuav txais lub neej ntawd formatting rau ib feem ntawm ib daim duab. Tag nrho cov khoom los yog cov ntsiab lus ntawm cov ntawv qhia yuav hloov.

Cov kev xaiv formatting rau kab kos yog feem ntau nyob ntawm peb lub tabs ntawm cov ntawv sau uas tau sau ua ke hu ua Daim Ntawv Cim

Feem ntau, peb cov tabs tsis pom. Kom nkag tau rau lawv, cia li nyem rau ntawm daim ntawv sau qhia koj nyuam qhuav tau tsim thiab peb lub tabs - Tsim, Layout, thiab Hom ntawv - ntxiv rau daim ntawv sau.

Saum toj no peb lub tabs no, koj yuav pom cov npe Daim Ntawv Ceeb Toom .

Nyob rau hauv cov seem hauv qab cov kauj ruam nram qab no formatting hloov yuav ua:

• Ntxiv daim ntawv qhia thiab lub npe co
• txav cov lus dab neeg mus rau sab saum toj ntawm daim phiaj
• Hloov xim thiab tom qab xim
• Npaj sab nraum ntug ntawm daim duab
• Resize daim ntawv qhia

Ntxiv ntawm kab rov tav Title

Cov kab rov tav qhia cov hnub hauv qab ntawm daim duab.

1. Nias ntawm daim ntawv sau qhia nyob rau hauv daim ntawv ua haujlwm los coj cov cuab yeej cuab tam tab
2. Nias ntawm Layout tab
3. Nias ntawm Axis npe los qhib lub npe sau npe
4. Nias rau hauv Kab Tsib Qib Yav Qis Title> Lub Hauv Paus Hauv qab Axis xaiv ntxiv lub npe Axis Title rau daim duab
5. Luag xaiv lub npe vim nws tseem ceeb
6. Ntaus hauv lub npe " Lub Hlis "

Muab lub npe ntawm lub npe Qib Thawj Lub Ntsig

Cov thawj ntsug axis qhia qhov ntim ntawm cov khoom muag raws sab laug ntawm daim duab.

1. Nyem ntawm daim ntawv qhia yog tsim nyog
2. Nias ntawm Layout tab
3. Nias ntawm Axis npe los qhib lub npe sau npe
4. Nias rau ntawm lub Koom Haum Me Nyuam Yaus Qis Title> Lub npe xaiv los ntxiv rau lub npe Axis Title rau daim phiaj
5. Nqa lub ntsiab lus tseem ceeb
6. Ntaus nyob hauv lub npe " Kev poob siab (mm) "

Muab lub npe hu ua Secondary Vertical Axis Title

Lub thij sab nraub qaum qhia tau hais tias cov nqi ntawm cov khoom lag luam muag raws sab xis ntawm daim duab.

1. Nyem ntawm daim ntawv qhia yog tsim nyog
2. Nias ntawm Layout tab
3. Nias ntawm Axis npe los qhib lub npe sau npe
4. Nias ntawm lub Secondary Vertical Axis Title> Lub npe xaiv los ntxiv lub npe Title Axis Title rau daim ntawv
5. Nqa lub ntsiab lus tseem ceeb
6. Ntaus nyob rau hauv lub npe " Nruab Nrab Kub (° C) "

Muab Daim Ntawv Chart Ntxiv

1. Nyem ntawm daim ntawv qhia yog tsim nyog
2. Nias ntawm Layout tab ntawm txoj kab
3. Nias ntawm Daim Ntawv Qhia Npe> Qho Txuas Txiaj Txim Siab ntxiv rau lub npe ntawm lub npe Chart Title rau daim ntawv qhia
4. Nqa lub ntsiab lus tseem ceeb
5. Ntaus hauv lub npe Climatograph for Acapulco (1951-2010)

Hloov daim ntawv Chart Title Font

1. Nyem ib zaug ntawm Chart Title los xaiv nws
2. Nias ntawm lub tsev tab ntawm daim ntawv tais cai
3. Nias rau hauv qab xub ntawm Font xim xaiv los qhib cov ntawv sau cia
4. Xaiv Xim Liab los hauv qab Xeem Xim ntawm daim ntawv qhia zaub mov

08 ntawm 09

Tsav Lus Tshaj Tawm thiab Hloov Cov Qauv Xeem Tom Ntej

Yog vim li cas, cov lus qhia hauv daim ntawv teev lus nyob rau ntawm sab xis ntawm daim ntawv qhia. Thaum peb ntxiv cov npe qis thij ob, tej yam tau txais me ntsis tuab neeg nyob hauv cheeb tsam ntawd. Yuav ua rau kom tsis txhob muaj lub congestion peb yuav tshem tawm cov lus dab neeg mus rau sab saum toj ntawm daim phiaj hauv qab daim ntaws ntawv.

1. Nyem ntawm daim ntawv qhia yog tsim nyog
2. Nias ntawm Layout tab ntawm txoj kab
3. Nias ntawm Lus dab neeg kom qhib lub npe cia
4. Nias on Show Legend rau Sab saum toj xaiv los rhais cov lus dab neeg mus rau hauv qab daim ntawv qhia npe

Siv Cov Ntawv Teev Npe Ntawv Tshaj Qhia Xaiv

Ntxiv nrog rau cov ntawv qhia cov cuab yeej ntawm cov kab ntawv, cov kev hloov cov ntawv tawm tuaj yeem ua rau cov kab kos siv los yog cov ntsiab lus ntsiab lus qhib thaum qhib rau ib qho khoom.

Hloov cov xim tom qab rau tag nrho daim duab thiab rau thaj tsam ntawm thaj chaw - lub npov nruab nrab ntawm daim duab uas qhia txog cov ntaub ntawv - yuav ua tiav nrog lub ntsiab lus teb cov ntawv qhia.

Hloov Chart Area Cheeb Tsam Xim

1. Txoj cai nias ntawm daim ntawv qhia dawb tom qab qhib cov ntawv qhia zaub mov
2. Nias rau ntawm tus me nyuam nqes mus rau sab xis ntawm Daim Piav Tom qab icon - xim muaj peev xwm - nyob hauv cov ntsiab lus ntawm lub ntsiab lus qhib lub ntsiab xim
3. Nias ntawm Dawb, Tom Qab 1, Tsau Ntawv Tawv 35% hloov daim npav tom qab xim tsaus nti

Hloov Lub Zajlus Tshaj Xim Tom Qab Xim

Lus Cim: Ceev faj tsis txhob xaiv cov kab sab tav toj ntawm lub plot thaj chaw es tsis yog tom qab nws tus kheej.

1. Txoj cai nias rau ntawm thaj chaw dawb thaj chaw tom qab qhib lub ntsiab lus teb thaj tsam ntsiab lus teb
2. Nias rau ntawm tus me nyuam nqes mus rau sab xis ntawm Daim Piav Tom qab icon - xim muaj peev xwm - nyob hauv cov ntsiab lus ntawm lub ntsiab lus qhib lub ntsiab xim
3. Nias ntawm Dawb, Tom Qab 1, Tawv Tsawg 15% hloov lub ntsiab lus thaj tsam tom qab xim rau lub teeb txho

09 ntawm 09

Ntxiv rau qhov 3-D Bevel Effect thiab Re-sizing Daim Ntawv Qhia

Ntxiv ntawm qhov 3-D bevel effect ntxiv me ntsis ntawm qhov tob. Nws yoojyim cov ntawv qhia nrog ib daim duab ci sab nraud.

1. Txoj cai nias ntawm daim duab tom qab qhib cov ntawv qhia zaub mov
2. Nias ntawm Daim Ntawv Chart Cheeb Tsam Xaiv nyob hauv cov ntsiab lus ntawm lub ntsiab lus qhib lub thawv ntawv sib tham
3. Nias rau ntawm 3-D Hom Ntawv nyob rau hauv qhov chaw nyob ntawm tus qauv hu ua Chart Area dialog box
4. Nias rau ntawm xub hauv qab rau sab xis ntawm sab saum toj icon nyob rau sab xis ntawm sab tes xis kom qhib lub vaj huam sib luag ntawm txoj kev xaiv
5. Nias ntawm lub voj voog rau hauv lub vaj huam sib luag - thawj qhov xaiv nyob rau hauv seem Bevel ntawm lub vaj huam sib luag
6. Nias lub khawm Kaw kaw lub thawv thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm

Re-sizing daim ntawv

Re-sizing daim duab yog lwm kauj ruam uas xaiv tau. Cov txiaj ntsim ntawm kev ua daim duab loj dua yog tias nws txo cov neeg coob uas tau tsim los ntawm ob sab xis ntawm sab xis ntawm sab xis ntawm daim duab.

Nws tseem yuav ua rau kom qhov loj ntawm thaj tsam ntawm daim duab ua cov ntaub ntawv yooj yim nyeem.

Qhov yooj yim tshaj plaws los mus hloov dua ib daim ntawv qhia yog siv cov cuaj kaum koj lub cev uas ua rau sab nraud ntawm daim npav thaum koj nias rau.

1. Nyem ib zaug hauv daim duab qhia tom qab xaiv tag nrho cov ntawv qhia
2. Kev xaiv cov ntawv qhia ntxiv ib txoj kab xiav kab rau sab nrauv ntawm daim duab
3. Nyob rau ntawm cov ces kaum ntawm cov kab xiav no yog cov qauv ntawm koj lub cev
4. Hover koj tus pointer nas dua ib qho ntawm cov fab kom txog rau thaum lub pointer hloov mus rau hauv ob lub taub hau dub xub
5. Thaum tus pointer yog qhov xub coj ob sab, nyem nrog tus nas laug khawm thiab rub tawm sab me ntsis ua ntug daim duab. Cov ntawv qhia yuav rov qab rau me me thiab dav dav. Cov cuab yeej tawm tswv yim yuav tsum nce siab ntxiv.

Yog tias koj tau ua raws li tag nrho cov kauj ruam hauv phau ntawv nyeem ntawm qhov no koj tus cim kos duab yuav tsum zoo li tus qauv hauv daim duab nyob rau thawj feem ntawm phau ntawv qhia no.