Excel Volume-High-Low-Punch Tshuag Market Chart

01 ntawm 09

Excel Tshuag lag luam daim ntawv qhia

Daim ntawv teev cov Tshuag Khoom-Ntev-Tsawg-Tshaj Tshaj lag luam yog ib hom qauv ntawm daim qauv los yog daim duab siv los ua ntej siv cov kev hloov ntawm tus nqi ntawm cov cuab yeej cuab tam - xws li cov stocks - dhau ib lub sijhawm.

Kev tivthaiv qhov ntawm daim ntawv qhia thiab lawv cov haujlwm yog:

• Cov kab ntsig khov rau ntawm daim duab qhia tias cov nqi ntawm cov khoom siv rau lub sij hawm ntev nrog rau sab saum toj ntawm kab uas qhia cov nqi siab tshaj plaws thiab hauv qab ntawm txoj kab qhia txog tus nqi qis tshaj
• Lub cim marker - daim duab peb sab. Qib siab ntawm daim duab peb sab pom tau tias tus nqi kaw rau qhov Tshuag Tawm
• Cov kab xiav ntsug qhia tias qhov sib pauv lossis pes tsawg ntawm cov khoom pauv rau lub sijhawm

Excel Tshuag lag luam daim ntawv qhia

Cov ntawv nyeem no tuaj yeem ua rau koj los ntawm kev tsim Daim Ntawv Cim-Qes-Tsav-Tshaj Tshuag lag luam hauv Excel.

Qhov kev nyeem ua ntej tsim ib daim ntawv sau npaj ua qauv thiab tom qab ntawd siv cov kev xaiv xa tawm los ntawm cov cuab yeej ntawm Daim Ntawv Ceebtoom rau ntawm daim qauv sau rau hauv daim duab uas tau pom hauv daim duab saum toj no.

Cov Ntsiab Lus Kawm

1. Nkag Mus thiab Xaiv Cov Ntaub Ntawv Chart
2. Tsim Tsa Daim Ntawv Qhia Ua Ntej-Ntev-Qes-Zej Zog
3. Siv daim ntawv teev cov ntawv qhia los ntxiv Chart thiab Axes Lub Titles
4. Formatting daim ntawv cim thiab qhov tseem ceeb
5. Sau lub cim Marker
6. Hloov Chart Area Cheeb Tsam Xim
7. Hloov Lub Zajlus Tshaj Xim Tom Qab Xim
8. Ntxiv rau qhov 3-D Bevel Effect thiab Re-sizing Daim Ntawv Qhia

02 ntawm 09

Nkag Mus thiab Xaiv Cov Ntaub Ntawv Chart

Nkag Mus Siv Cov Ntawv Qhia Cov Ntawv Qhia

Thawj kauj ruam hauv kev tsim Daim Ntawv Cim-Qes-Qes-Caj yog sau cov ntaub ntawv rau hauv daim ntawv ua haujlwm .

Thaum nkag mus rau cov ntaub ntawv , khaws cov cai tswj no:

• Thaum twg ua tau, sau koj cov ntaub ntawv hauv txhua raws li muaj nyob hauv daim duab saum toj no
• Tso tawm koj daim ntawv ua haujlwm nrog lub npe rau txhua daim ntawv xov xwm rau sab saum toj ntawm kem thiab cov ntaub ntawv hauv lub hlwb hauv qab no
• Tsis txhob tso daim ntawv dawb los yog txhua kab ntawv thaum nkag hauv koj cov ntaub ntawv raws li qhov no yuav tsim ib qho chaw seem hauv daim duab

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 ntawv xaiv tau muaj nyob rau hauv no Basic Excel Formatting Tutorial .

Xaiv cov ntawv qhia cov ntawv

Thaum cov ntaub ntawv tau muab ntaus nkag lawm, cov kauj ruam tom ntej yog xaiv cov ntaub ntawv los ua qauv.

Hauv daim ntawv ua haujlwm, tsuas yog ib feem ntawm cov ntaub ntawv yuav nquag muaj nyob rau hauv ib daim duab. Xaiv lossis highlighting cov ntaub ntawv, yog li ntawd, qhia Excel cov lus qhia dab tsi rau thiab muaj dab tsi tsis pom zoo.

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

Cov Kauj Ruam Tutorial:

1. Sau cov ntaub ntawv raws li pom hauv daim duab saum toj no rau hauv hlwb A1 rau E6.
2. Xaiv lub hlwb A2 rau E6 los saib lawv

03 ntawm 09

Tsim Tsa Daim Ntawv Qhia Ua Ntej-Ntev-Qes-Zej Zog

Tag nrho cov kab kos yog pom nyob hauv Insert tab ntawm txoj cai hauv Excel.

Tso koj tus nas pointer ntau dua li cov 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.

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.

Tom qab ntawd, nws yog nyob rau ntawm koj los tsim hom ntawv qhia siv cov qauv cuab yeej .

Cov Kauj Ruam Tutorial:

1. Yog tias koj siv Excel 2007 lossis Excel 2010, nias ntawm Txuas> Lwm Kab Ntawv> Tshuag> Ntim-Qes-Qes-Zej Zog nyob rau hauv txoj kab
2. Yog tias koj siv Excel 2013, nias ntawm Insert> Insert Stock, Surface los Radar Charts> Tshuag> Volume-High-Low-Close in the ribbon
3. Daim ntawv sau qhia txog kev lag luam hauv qib pib, zoo ib yam li cov duab pom saum toj no, yuav tsum tau tsim thiab muab tso rau hauv koj daim ntawv ua haujlwm .

Cov kauj ruam ntxiv nyob hauv phau ntawv nyeem ua daim ntawv qhia no kom phim cov duab uas tau muab tso rau hauv Page 1.

04 ntawm 09

Siv cov Ntawv Cuab Yeej

Cov Cuab Yeej Txheej txheem cej luam

Thaum nws los tawm qauv cov kab kos hauv Excel, nws yog ib qho tseem ceeb kom nco ntsoov tias koj tsis tas yuav lees txais qhov default formatting rau ib qho ntawm 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 .

Hauv kev qhia cov kauj ruam hauv qab no peb yuav ntxiv thiab rho tawm lub npe ntawm lub npe thiab lub npe ntawm daim ntawv thiab lub npe ntawm daim ntawv qhia cov lus qhia uas muaj nyob rau hauv daim ntawv qhia cov cuab yeej ntawm Layout tab.

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 nyob rau hauv lub npe " Hnub "

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. Luag xaiv lub npe vim nws tseem ceeb
6. Ntaus hauv lub npe " Ntim "

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. Luag xaiv lub npe vim nws tseem ceeb
6. Ntaus nyob rau hauv lub npe " Tshuag Nqe "

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. Luag xaiv lub npe vim nws tseem ceeb
5. Ntaus nyob rau hauv lub npe hauv qab ntawm ob kab - siv Tus Ntaus Ntxov rau ntawm cov keyboard kom phua cov kab: Cov Khw Muag Khoom Khw Tshaj Lij Thiab Cov Nqi

Tsiv daim ntawv Qhia Lus

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

05 ntawm 09

Ua Qauv Qhia Cov Ntawv Qhia thiab Cov Nqi

Font ntaus ntawv xaiv

Nyob rau hauv cov kauj ruam dhau los, nws tau hais tias feem ntau ntawm cov kev xaiv formatting rau kab kos tau nyob hauv Chart Titles .

Ib pawg ntawm kev xaiv cov kev xaiv uas tsis nyob ntawm no yog cov ntawv nyeem cov cuab yeej - xws li ntawv loj thiab xim, kos duab, ntawv yeem, thiab ua kom sib haum.

Cov no tuaj yeem pom nyob rau hauv Tsev Tsev ntawm txoj kab ntawv - font.

Excel Right Click Menus thiab Toolbar

Ib qho yooj yim, tab sis, ntawm kev nkag mus rau cov kev xaiv no yog los ntawm txoj cai rau ntawm lub npe uas koj xav tau hom ntawv.

Ua li ntawd yuav qhib cov cai-nias lossis cov ntsiab lus teb hauv lub ntsiab lus uas muaj xws li ib qho me me formatting toolbar.

Vim nws yog ib feem ntawm lub ntsiab lus teb cov ntawv qhia, cov kev xaiv formatting ntawm qhov toolbar hloov nyob ntawm seb koj tau clicked rau.

Piv txwv, yog tias koj txoj cai-nias rau ntawm ib qho xiav ntim tuav hauv cov ntawv qhia koj tus khab seeb muaj cov kev xaiv cov kev xaiv uas siv tau nrog daim ntawv qhia no.

Txoj cai-txhaj ib qho ntawm cov vuas lossis cov lus dab neeg muab rau koj muab cov ntawv xa tawm cov ntawv zoo sib xws rau cov neeg pom hauv lub Tsev tab ntawm txoj cai.

Daim Ntawv Teev Npe Shortcut

Nyob rau hauv lub kauj ruam ntawm kev nyeem, peb xav hloov cov xim ntawm txhua lub npe, cov lus dab neeg, thiab qhov tseem ceeb - cov lej thiab cov hnub nyob rau hauv qhov kev ntsuas siab - mus rau xim xiav uas zoo ib yam li ntawm lub ntim tuav.

Ntau dua li ua nyias ib leeg, peb tuaj yeem txuag tau qee lub sijhawm los ntawm kev hloov cov xim ntawm txhua daim ntawv lo thiab qhov tseem ceeb hauv daim duab.

Qhov shortcut no yuav xaiv tag nrho cov ntawv qhia los ntawm txhaj rau cov tom qab dawb es tsis txhob nias ntawm cov ntsiab lus ntawm tus neeg,

Taw Qhia Tag Nrho Cov Ntawv Qhia thiab Cov Nqi

1. Txoj cai nias ntawm daim ntawv qhia dawb tom qab qhib cov ntawv qhia zaub mov
2. Ndliv qhov me me cia rau ntawm sab xis ntawm cov xim Colour icon hauv lub ntsiab lus teb ntawm lub ntsiab lus qhib lub ntsiab xim xim
3. Nias ntawm xiav Accent 1, Darker 25% los hloov tag nrho cov ntawv lo thiab qhov tseem ceeb hauv daim ntawv qhia rau qhov xim ntawd

Shrinking Chart Title Font Size

Lub plaus loj font rau daim ntawv qhia npe yog 18 point uas dwarfs lwm cov ntawv nyeem thiab kuj txo lub ntsiab lus teb ntawm daim phiaj. Yuav kom kho qhov teeb meem no peb yuav tso tawm cov ntawv qhia lub npe ntawv loj rau 12 ntsiab lus.

1. Nias ntawm Chart Title los xaiv nws - nws yuav tsum tau surrounded los ntawm ib lub thawv
2. Luag xaiv lub npe kom pom tseeb
3. Txoj cai-nias ntawm lub npe tseem ceeb los qhib lub ntsiab lus teb ntawv qhia zaub mov
4. Nias rau ntawm txoj hlua me me mus rau ntawm sab xis ntawm Daim Ntawv Ceebtoom Symbol icon - tus xov tooj 18 nyob rau sab saum toj kab ntawm lub ntsiab lus teb ntawm lub ntsiab lus teb - qhib qhov sau cia ntawm cov ntawv muaj ntau qhov font
5. Nias rau ntawm 12 hauv daim ntawv los hloov daim ntawv sau npe font rau 12 point
6. Nias rau ntawm daim ntawv qhia keeb kwm kom tshem tau lub ntsiab ntawm daim ntawv qhia npe
7. Daim duab thaj av ntawm daim duab yuav tsum nce siab

06 ntawm 09

Sau lub cim Marker

Lub neej nyob ze kos rau daim ntawv qhia - uas qhia tau hais tias cov nqi kaw tshuag - yog kab me me kab rov tav. Nyob rau hauv peb daim duab, tus cim kos npe yuav luag tsis pom - tshwj xeeb tshaj yog thaum nws nyob hauv nruab nrab ntawm xiav ntim tuav li ntawm 6, 7, thiab 8 ntawm Lub Ob Hlis.

Yuav kom kho qhov teeb meem no, peb yuav hloov tus cim rau ib qho peb tog uas qhov chaw saum toj kawg nkaus nruab nrab yog nqe kaw cov khoom seem rau hnub ntawd.

Peb tseem yuav pauv qhov loj thiab xim ntawm daim duab peb sab rau daj kom nws tawm tsam xiav tus qauv ntawm lub ntim tuav.

Lus Cim : Yog tias peb hloov tus cwj pwm ze - hais rau lub Ob Hlis 6 - tsuas yog tus kos rau hnub ntawd yuav hloov - lub ntsiab lus peb yuav tsum rov ua tib co plaub zaug los hloov tag nrho cov cim.

Txhawm rau pauv tus cim rau tag nrho plaub hnub ntawm ib zaug thaum peb xav hloov Cov Lus Cog Tseg nyob rau hauv daim duab.

Cov Kauj Ruam Tutorial

Raws li nyob rau hauv lub ruam dhau los ntawm kev nyeem, peb yuav siv cov ntsiab lus teb lus qhia kom tiav cov kauj ruam no.

Hloov Cov Cim Nco

1. Nyem ib zaug ntawm cov lus dab neeg xaiv nws - nws yuav tsum tau surrounded los ntawm ib lub thawv
2. Nyem ib zaug ntawm lo lus kaw nyob rau hauv cov lus dab neeg xaiv nws - cia li lo lus kaw yuav tsum tau surrounded ntawm lub thawv
3. Txoj cai nias ntawm lo lus kaw kom qhib lub ntsiab lus teb cov ntawv qhia
4. Nias ntawm Hom Ntawv Xaiv Cov Ntaub Ntawv xaiv nyob rau hauv cov ntsiab lus ntawm lub ntsiab lus teb qhib lub thawv tawm tswv yim
5. Nias ntawm Marker Sau nyob rau hauv qhov kev txiav txim sab nrauv ntawm Hom Ntawv Qhia Tshaj Tawm Lus
6. Nias ntawm Daim Ntawv Sau nyob rau hauv txoj cai ntawm tes ntawm lub thawv sab nraud
7. Nias ntawm qhov xub xub mus rau sab xis ntawm Colour icon nyob rau hauv txoj cai tes qhib qhib Colours vaj huam sib luag
8. Nias rau daj raws li lub Txuj Xim kom hloov xim xim rau daj
9. Tawm lub thawv ntawv qhib rau lub kauj ruam tom ntej hauv phau ntawv nyeem

Hloov Cov Cim Nias thiab Qhov Cuam

1. Nias ntawm Marker Options nyob rau hauv lub qhov rais ntawm daim qauv hu ua Format Data Series
2. Nias ntawm qhov ua hauv qab Marker Yam kev xaiv nyob rau hauv txoj cai ntawm tes ntawm lub thawv sab nraud
3. Ndliv lub khawm rau sab xis ntawm txoj cai ntawm Hom ntawv nyob rau sab xis ntawm txoj cai los qhib lub npe cia
4. Nias ntawm daim duab peb sab hauv daim ntawv los hloov tus cim kos npe
5. Hauv Ntev , kev xaiv nce qhov loj ntawm daim duab peb sab mus rau 8
6. Nias lub khawm Kaw kaw lub thawv thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm .

07 ntawm 09

Hloov Chart Area Cheeb Tsam Xim

Hloov xim tom qab ntawm tag nrho daim duab, peb yuav rov qab siv cov ntsiab lus teb lus qhia. Cov xim xaiv hauv cov ntsiab lus teb tau teev tseg raws li xim xim dawb txawm tias nws zoo li ntau grey dua dawb.

Cov Kauj Ruam Tutorial:

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. Ndliv Dawb, Background 1, Darker 25% hloov daim ntawv tom qab xim xim mus rau txho

08 ntawm 09

Hloov Lub Zajlus Tshaj Xim Tom Qab Xim

Cov kauj ruam rau kev hloov xim tom qab ntawm qhov thaj tsam yuav luag zoo tib yam rau cov neeg hloov xim tom qab rau tag nrho daim phiaj.

Cov xim xaiv rau daim ntawv qhia no tshwm sim li xiav xiav txawm tias nws tau teev cia li xiav xiav hauv cov xim vaj huam sib luag.

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.

Cov Kauj Ruam Tutorial:

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. Ndliv tsaus nti, Phau ntawv 2, Ntaus 80% los hloov lub ntsiab lus thaj tsam tom qab xim xim xiav.

09 ntawm 09

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

Ntxiv ntawm 3-D Bevel Effect

Ntxiv qhov 3-D nyhuv nyhuv yog qhov tseeb ntawm cov khoom qab zib uas txuas ntxiv ntawm qhov tob rau ntawm qhov qhia. Nws yoojyim cov ntawv qhia nrog ib daim npog sab nraud.

1. Txoj cai nias ntawm daim ntawv qhia dawb 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 kev txiav txim sab laug ntawm Daim Ntawv Qhia Chart Area dialog
4. Nias rau ntawm xub xub mus rau sab xis ntawm sab saum toj lub qhov rais nyob sab xis ntawm lub qhov rais qhib lub vaj huam sib luag ntawm txoj kev xaiv
5. Nias ntawm txoj kev xaiv ntawm Convex hauv lub vaj huam sib luag kom teeb ib lub ntug rau sab nraud
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 no tau ob tus xub xub xa, nias ntawm sab laug nas khawm thiab rub me ntsis sab nraud los 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 no ntawm qhov no koj qhov Volume-High-Low-Stock Stock Chart yuav zoo ib yam li tus qauv hauv daim duab nyob rau nplooj 1 hauv phau ntawv no.