Yuav Ua Li Cas Sau Sijhawm Sijhawm hauv Excel

2024 Tus sau: Abigail Brown | [email protected]. Kawg hloov kho: 2023-12-17 06:49

Yuav Paub

• Hands-down easyest: Go to Insert > SmartArt > Process >Basic Timeline > OK thiab sau koj cov ntaub ntawv.
• Lwm txoj kev xaiv: Tsim cov phiaj xwm tawg los ntawm qhov tseem ceeb ntawm koj lub rooj thiab mus rau Insert > Scatter Plot, tom qab ntawd hloov daim ntawv los ua ib ncua sij hawm.

Yog tias koj tab tom npaj ib qhov project lossis kaw cov xwm txheej, kawm paub tsim lub sijhawm hauv Excel tuaj yeem pab tau. Lub sijhawm ncua sij hawm pab koj taug qab txhua yam los ntawm cov ntsiab lus tseem ceeb mus rau cov xwm txheej me me. Kab lus no piav qhia yuav ua li cas los tsim lub sijhawm hauv Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Excel rau Mac.

Tsim Excel ncua sij hawm ntse Graphic

Excel muaj cov duab ua ntej koj tuaj yeem siv los tsim lub sijhawm hauv Excel. Cov duab no yog ib feem ntawm Excel's SmartArt sau thiab siv tau yooj yim heev.

Lub sijhawm SmartArt yog ib txoj hauv kev yooj yim ntawm kev tsim lub sijhawm ncua sij hawm uas koj tuaj yeem ntxig txhua qhov chaw rau hauv daim ntawv Excel. Txawm li cas los xij, nws tsis tso cai rau koj los sau npe txhua lub ntsiab lus siv ntau yam hauv koj daim ntawv ua haujlwm. Koj yuav tsum tau manually sau daim ntawv lo rau txhua lub sij hawm taw tes. Vim li no, SmartArt ncua sij hawm yog qhov zoo tshaj plaws rau ncua sij hawm luv.

1. Txhawm rau tsim SmartArt ncua sij hawm, xaiv Insert los ntawm cov ntawv qhia zaub mov, thiab hauv Illustrations pawg xaiv SmartArt.

   

2. Nyob rau hauv Xaiv SmartArt Graphic qhov rais, xaiv Txheej txheem ntawm sab laug pane. Koj yuav pom ob lub sijhawm xaiv; Basic Timeline thiab Circle Accent TimelineLub Sijhawm Sijhawm Yooj Yim yog qhov zoo tshaj plaws rau cov kab ke ib txwm muaj raws li cov neeg feem coob paub. Lub Circle Accent ncua sij hawm qhia lub voj voog rau txhua txoj haujlwm ua ke. Qhov kev xaiv no muab qhov tshwj xeeb tshaj plaws rau koj lub sijhawm. Xaiv ib qho ntawm cov kev xaiv no thiab tom qab ntawd xaiv OK

   

3. Nyob hauv lub thawv ntawv uas hais tias Tau koj cov ntawv ntawm no, koj tuaj yeem ntaus ib daim ntawv lo rau txhua qhov taw qhia hauv ncua sij hawm. Qhov no yog tus txheej txheem phau ntawv, yog li nws yog qhov zoo tshaj plaws rau lub sijhawm luv luv yam tsis muaj ntau lub ntsiab lus thoob plaws.

   

4. Thaum koj xaiv ib lub xov tooj ntawm tes hauv daim ntawv nthuav qhia, lub pane nkag yuav ploj mus. Koj tuaj yeem hloov kho lub sijhawm ncua sij hawm yav tom ntej nrog kev nkag ntxiv tsuas yog xaiv nws thiab rov ua cov txheej txheem saum toj no.

   

SmartArt ncua sij hawm hauv Excel yog qhov zoo tshaj plaws rau kev tsim sai heev, ncua sij hawm me me uas koj tuaj yeem siv los taug qab cov haujlwm yooj yim lossis ib qho phiaj xwm uas cuam tshuam nrog qee qhov xwm txheej. Txawm li cas los xij, yog tias koj tab tom tswj hwm qhov project loj dua nrog cov npe ntev ntawm cov haujlwm, lossis yog tias koj siv cov ntawv qub ntawm Excel, Scatter Plot ncua sij hawm piav qhia hauv qab no yuav yog qhov kev xaiv zoo dua.

Tsim Excel ncua sij hawm los ntawm Scatter Plot

Yog tias koj muaj qhov qub ntawm Excel, koj tsis muaj hmoo. Muaj ib txoj hauv kev zoo tshaj plaws uas koj tuaj yeem siv los tig cov phiaj xwm tawg rau hauv cov sijhawm teem sijhawm zoo.

Lub Scatter Plot hauv excel tso cai rau koj ua cov duab kos hauv cov kab ke sib txuas hauv ib daim duab. Vim li no, nws ua rau lub platform zoo tshaj plaws rau koj kom xaj khoom hauv kab ncaj nraim, teeb tsa los ntawm hnub. Los ntawm formatting lub scatter zajlus kom zoo, koj muaj peev xwm hloov nws mus rau hauv ib tug muaj txiaj ntsim daim duab ncua sij hawm uas dynamically hloov raws li cov dej num thiab hnub nyob rau hauv koj thawj qhov project spreadsheet.

txheej txheem no siv sijhawm me ntsis ntau dua li qhov kev xaiv ncua sij hawm saum toj no, tab sis thaum kawg koj tuaj yeem kho nws kom haum rau koj lub hom phiaj.

Txoj kev no ntawm kev tsim lub sijhawm los ntawm cov phiaj xwm tawg ua haujlwm yog tias koj siv cov ntawv Excel tshiab dua li Excel 2007.

1. Txhua qhov haujlwm xav tau sijhawm sijhawm zoo, tab sis ua ntej koj tuaj yeem pom lub sijhawm ncua sijhawm, koj yuav tsum tsim daim ntawv tshaj tawm uas muaj txhua kauj ruam hauv qhov project nrog rau hnub kawg. Txhawm rau pib, nws kuj yog ib lub tswv yim zoo los tsim "Milestone" kem thiab ntsuas qhov tseem ceeb ntawm txhua qhov tseem ceeb ntawm qhov ntsuas ntawm 1 txog 4. Qhov ntsuas no yuav hloov tom qab los ua ib txoj hauv kev kom pom cov sij hawm zoo dua (saib hauv qab).

   

2. Txoj kev no ntawm kev tsim lub sijhawm pom kev cuam tshuam nrog kev hloov pauv Scatter Plot. Yog li, txhawm rau pib, taw qhia tag nrho cov lus koj tau xaiv. Tom qab ntawd, xaiv lub Insert ntawv qhia zaub mov thiab xaiv Scatter Plot los ntawm kab kos pawg.

   

3. Tom ntej, xaiv cov ntaub ntawv tshwj xeeb rau ncua sij hawm los ntawm txoj cai nyem rau ntawm daim duab thiab xaiv Xaiv cov ntaub ntawv.

   

4. In the Legend Entries (Series) pane, xaiv Edit.

   

5. Tso koj tus cursor rau hauv Xaiv X qhov tseem ceeb teb, thiab tom qab ntawd taw qhia tag nrho cov kab uas muaj koj cov hnub tas sij hawm thoob plaws hauv qhov project. Qhov no yuav siv cov hnub tas sij hawm ntawm tus kheej rau cov ntsiab lus mos txwv hauv ncua sij hawm.

6. Tom ntej no, xaiv qhov Xaiv Y qhov tseem ceeb teb, thiab qhia tag nrho cov kab uas muaj koj qhov kev ua haujlwm tseem ceeb rau txhua yam haujlwm. Cov no yuav txhais qhov siab ntawm txhua qhov taw tes hauv ncua sij hawm. Xaiv OK thaum koj ua tiav.

   

7. Lub sijhawm no koj muaj lub sijhawm zoo zoo nkauj, txawm li cas los xij tseem muaj cov qauv ntxiv uas koj yuav tsum tau ua txhawm rau ua kom ncua sij hawm tso saib cov hnub thiab cov haujlwm kom meej meej.

   

8. Xaiv lub + icon nyob rau sab xis sab xis ntawm daim ntawv qhib rau Daim Ntawv Qhia lub thawv sib tham. Deselect Daim Ntawv Teev Npe thiab Gridlines txhawm rau muab sijhawm rau saib kom huv.

   

9. Tom ntej no, xaiv tus xub nyob ib sab ntawm Axes, thiab tshem tawm Primary Vertical kom tshem tawm cov ntawv cim ntsug ntawm lub sijhawm. Qhov no hloov lub sijhawm ncua mus rau hauv kab kab rov tav nrog cov hnub, thiab cov haujlwm ntawm tus kheej sawv cev ua cov dots nrog qhov siab txhais los ntawm koj cov txiaj ntsig tseem ceeb rau txoj haujlwm ntawd.

   

10. Tseem nyob hauv Daim Ntawv Qhia , xaiv Yam Bars txhawm rau ua kom hla qhov yuam kev rau txhua qhov taw qhia. Cov kab no yuav hloov mus rau hauv kab ntsug rau txhua yam haujlwm hauv koj lub sijhawm. Tab sis los tsim cov kab ntsug no, koj yuav tsum hloov kho qhov yuam kev bar tshwm li cas.

    

11. Yuav ua li cas, nyem rau ntawm kab hauv qab ntawm daim ntawv thiab xaiv Format Axis.

    

12. Xaiv tus xub poob ntawm ib sab Axis Options thiab xaiv tus X yuam kev Bars xaiv.

    

13. Nyob hauv cov kev xaiv no, xaiv Tsis muaj kab. Qhov no yuav tshem tawm cov kab kab rov tav los ntawm txhua lub sijhawm cov ntsiab lus, thiab tsuas yog kab ntsug yuav nyob twj ywm.

    

14. Tom ntej no, koj yuav xav kom txoj kab ntsug tsuas yog ncav cuag txhua lub sijhawm, tab sis tsis siab dua. Txhawm rau ua qhov no, koj yuav tsum hloov kho Y yuam kev Bars. Txoj nyem rau hauv qab axis ntawm daim ntawv dua thiab xaiv Format Axis Xaiv Axis Options thiab xaiv Y yuam kev Barslos ntawm daim ntawv teev npe poob.

    

15. Xaiv daim ntawv qhia bar, thiab hloov qhov Kev taw qhia xaiv rau Minus Hauv qab Yam Nyiaj , xaiv Percentage, thiab hloov daim teb mus rau 100% Cov kev hloov no yuav ua rau txoj kab ntsug nres ntawm lub sijhawm. Nws tseem yuav ncab txoj kab ntsug "kev ua yuam kev" los ntawm axis mus txog rau txhua qhov taw tes.

    

16. Tam sim no koj ncua sij hawm zoo li ib qho hauv qab no, nrog cov ntsiab lus ncua sij hawm sib kis thoob plaws thiab muab tso rau hnub, nrog txoj kab ntsug ncab los ntawm hnub ua hauj lwm mus txog rau lub sij hawm taw tes nws tus kheej.

    

17. Txawm li cas los xij, txhua lub sijhawm taw qhia tsis tau piav qhia ntau. Nws tsuas yog qhia lub sijhawm ncua sij hawm tseem ceeb uas koj tau muab rau txhua qhov taw qhia. Hloov chaw, koj yuav xav sau txhua lub ntsiab lus nrog lub npe ua haujlwm.

    

18. Yuav ua li no, rov qab mus rau Axis Options dropdown thiab xaiv Data Labels.

    

19. Koj yuav pom lub thawv Cov Ntawv Sau Cov Ntawv Qhia tshwm. Xaiv qhov Data Label Range teb thiab tom qab ntawd xaiv qhov ntau ntawm cov hlwb nrog cov lus piav qhia ua haujlwm. Xaiv OK kom tiav.

    

20. Tam sim no, koj yuav pom tag nrho cov lus piav qhia ua haujlwm tshwm sim raws li cov ntaub ntawv sau rau txhua kis. Raws li koj tuaj yeem pom, thaum qhov no ua rau txhua lub ntsiab lus piav qhia ntau dua, nws kuj tseem ua rau muaj kev cuam tshuam me ntsis rau koj lub sijhawm.

    

21. Koj pib kho qhov no los ntawm kev hloov kho tus nqi tseem ceeb rau txhua yam haujlwm. Thaum koj kho qhov tseem ceeb, nws yuav nce lossis txo qhov siab ntawm qhov taw tes hauv ncua sij hawm.

    

22. Txawm tias qhov no ua haujlwm zoo los txhim kho lub sijhawm, koj yuav tsis tuaj yeem nthuav tawm cov ntsiab lus ncua sij hawm sib nrug txaus kom ncua sij hawm kom meej. Qhib qhov Axis Options dua, thiab xaiv daim ntawv qhia bar icon. Hauv qab Bounds, kho qhov Minimum thiab Maximum teb. Nce Yam tsawg kawgyuav txav thawj qhov tseem ceeb ze rau ntawm ntug sab laug ntawm ncua sij hawm. Kev txo qis siab tshaj yuav txav lub sijhawm kawg mus rau sab xis ntawm koj lub sijhawm.

    

23. Thaum koj ua tiav tag nrho cov kev hloov pauv no, koj lub sijhawm yuav tsum tau teeb tsa kom zoo, nrog ntau chav rau txhua daim ntawv sau ua haujlwm. Tam sim no koj muaj ib lub sij hawm uas qhia meej txog tag nrho cov phiaj xwm ncua sij hawm thiab hnub ntawm txhua qhov tseem ceeb txij thaum pib mus txog qhov kawg.

    

24. Raws li koj tuaj yeem pom, kev siv cov phiaj xwm tawg yuav siv zog me ntsis ntxiv los tsim cov sijhawm qhia, tab sis thaum kawg qhov kev siv zog ua rau lub sijhawm tsim tau zoo uas txhua tus yuav txaus siab.