Excel cia koj muab ob lossis ntau daim duab sib txawv lossis cov duab sib txawv kom nws yooj yim dua los tso saib cov ntaub ntawv cuam tshuam ua ke. Ib txoj hauv kev yooj yim kom ua tiav txoj hauj lwm no yog los ntawm kev ntxiv qhov thib ob ntsug lossis Y axis rau sab xis ntawm daim ntawv. Ob pawg ntawm cov ntaub ntawv tseem qhia txog X lossis kab rov tav axis nyob hauv qab ntawm daim ntawv.
Cov lus qhia no siv rau Excel 2019, 2016, 2013, 2010, thiab Excel rau Microsoft 365.
Yuav ua li cas muab ob daim duab hauv Excel
Koj tuaj yeem txhim kho qhov kev nthuav qhia ntawm ob cov ntaub ntawv teev tseg los ntawm kev xaiv cov kab ntawv sib ntxiv, xws li kab ntawv kab thiab kab kab.
Kev siv ntau rau hom kev sib xyaw ua ke no suav nrog kev qhia qhov nruab nrab txhua hli kub thiab nag lossis daus cov ntaub ntawv ua ke, tsim cov ntaub ntawv xws li cov khoom tsim thiab cov nqi tsim khoom, lossis cov ntim muag txhua hli thiab cov nqi muag txhua hli.
Ua ntej, koj yuav tsum tsim cov kab ke yooj yim.
Cov lus qhia tsis suav nrog cov kauj ruam rau formatting daim ntawv ua haujlwm raws li qhia hauv daim duab saum toj no. Cov ntaub ntawv ntawm kev xaiv hom ntawv ua haujlwm muaj nyob rau hauv qhov yooj yim Excel formatting tutorial.
-
Tau cov ntaub ntawv raws li pom hauv daim duab rau hauv cov hlwb A1 rau C14.
Image -
Xaiv hlwb A2 rau C14,ntau yam ntawm cov ntaub ntawv koj yuav suav nrog hauv kab ntawv.
Image -
Xaiv tus Insert tab ntawm kab.
Image -
Nyob hauv kab kos ntu, xaiv kab ntawv qhia bar thiab xaiv qhov 2-D Clustered Kem.
Image - Ib kab ntawv kab ke yooj yim yog tsim thiab muab tso rau hauv daim ntawv ua haujlwm.
Hloov cov ntaub ntawv rau kab kab
Hloov hom kab ntawv hauv Excel yog ua tiav siv Hloov Daim Ntawv Qhia Hom dialog box. Txij li thaum peb xav hloov tsuas yog ib qho ntawm ob cov ntaub ntawv nthuav tawm rau ib hom kab ntawv sib txawv, peb yuav tsum qhia Excel qhov twg nws yog. Koj tuaj yeem ua qhov no los ntawm kev xaiv, lossis nyem ib zaug, ntawm ib kab hauv kab ntawv, uas qhia txog txhua kab ntawm tib xim.
Kev xaiv qhib lub Hloov Daim Ntawv Qhia Hom dialog box suav nrog:
- Clicking on the Change Chart Type icon on the Designtab of the ribbon.
- Right-clicking ntawm ib qho ntawm cov kab ntawv xaiv thiab xaiv Hloov Series Daim Ntawv Qhiakev xaiv los ntawm cov ntawv qhia zaub mov.
Lub dialog box teev txhua hom kab ntawv muaj, yog li nws yooj yim hloov ntawm ib daim ntawv mus rau lwm qhov.
-
Nyob hauv daim ntawv, xaiv ib qho ntawm cov ntaub ntawv kub los xaiv txhua kab ntawm cov xim ntawd (xiav hauv qhov no) hauv daim ntawv.
Image -
Hover tus nas pointer hla ib kab ntawm cov kab no thiab nyem rau sab xis los qhib cov ntawv qhia zaub mov nco-down.
Image -
Xaiv lub Hloov Series Daim Ntawv Qhia kev xaiv los ntawm cov ntawv qhia zaub mov kom qhib lub Hloov kab ntawv hom dialog box.
Image -
Xaiv thawj kab kab kev xaiv hauv Daim Ntawv Qhiadaim ntawv.
Image - Xaiv OK txhawm rau kaw lub dialog thiab rov qab mus rau daim ntawv ua haujlwm.
- Nyob rau hauv daim ntawv, cov ntaub ntawv kub yuav tsum tam sim no tso tawm raws li kab xiav.
Txiv cov ntaub ntawv mus rau qhov thib ob Y-Axis
Hloov cov ntaub ntawv ntsuas kub rau ib kab teeb yuav ua rau nws yooj yim dua rau kev paub qhov txawv ntawm ob cov ntaub ntawv teev, tab sis, vim tias lawv ob leeg tau npaj rau tib txoj kab ntsug, cov ntaub ntawv kub yog ib txoj kab ncaj nraim uas qhia peb. me ntsis txog qhov kub thiab txias txhua hli.
Cov ntaub ntawv kub zoo li qhov no vim tias qhov ntsuas ntawm txoj kab ntsug yog sim ua kom haum rau ob cov ntaub ntawv uas sib txawv ntawm qhov loj. Qhov nruab nrab kub cov ntaub ntawv tsuas yog ib qho me me ntawm 26.8 txog 28.7 degrees Celsius, thaum cov ntaub ntawv nag lossis daus txawv ntawm tsawg dua peb millimeters tshaj 300 hli.
Nyob rau hauv kev teeb tsa qhov ntsuas ntawm txoj kab ntsug kom pom ntau yam ntawm cov ntaub ntawv nag lossis daus, Excel tau tshem tawm cov tsos ntawm qhov sib txawv ntawm cov ntaub ntawv kub rau xyoo. Tsiv cov ntaub ntawv kub mus rau qhov thib ob ntsug axis, tso tawm rau sab xis ntawm daim ntawv qhia, tso cai rau cais cov nplais rau ob cov ntaub ntawv ntau yam.
- Nyem ib zaug ntawm kab ntsuas kub los xaiv nws.
-
Hover the mouse pointer over the line and right-click with the mouse to open the drop-down context menu.
Image - Xaiv lub Format Data Series kev xaiv los ntawm cov ntawv qhia zaub mov kom qhib lub Format Data Series dialog box.
-
Xaiv qhov Secondary Axis kev xaiv nyob rau hauv lub pane ntawm lub dialog box.
Image - Xaiv lub X khawm kom rov qab mus rau daim ntawv ua haujlwm.
- Nyob rau hauv daim ntawv, qhov ntsuas rau cov ntaub ntawv kub yuav tsum tam sim no tshwm rau sab xis.
Ntxiv qhov Y-Axis thib ob rau daim ntawv Excel
Qhov piv txwv no qhia tau hais tias yuav ua li cas sib txuas kab thiab kab kab kos los tsim cov duab huab cua lossis climatograph, uas qhia qhov nruab nrab txhua hli kub thiab nag lossis daus rau qhov chaw muab.
Raws li pom hauv daim duab saum toj no, kab ntawv kab ntawv, lossis kab duab kab, qhia qhov nruab nrab nag lossis daus txhua hli thaum kab teeb qhia qhov ntsuas kub nruab nrab.
Ib co lus ceeb toom:
- Cov kab kos sib xyaw yuav tsum qhia tus nqi X-axis (kab rov tav) xws li lub sijhawm lossis qhov chaw.
- Tsis yog txhua hom kab ntawv tuaj yeem ua ke, suav nrog 3-D kab kos.
Feem ntau, cov txheej txheem los tsim ib daim ntawv qhia ua ke yog raws li hauv qab no:
- Tsim ib daim ntawv qhia ob sab hauv kab ke, uas qhia ob qho tib si nag lossis daus thiab kub cov ntaub ntawv hauv cov xim sib txawv.
- Hloov hom kab ntawv rau cov ntaub ntawv kub ntawm txhua kab rau kab.
- Txav cov ntaub ntawv ntsuas kub los ntawm thawj axis ntsug (sab laug ntawm daim duab) mus rau theem nrab ntsug axis (sab xis ntawm daim duab).
Raws li qhov tshwm sim ntawm kev hloov cov ntaub ntawv kub mus rau qhov thib ob ntsug axis, kab qhia tias cov ntaub ntawv qhia tau ntau dua qhov hloov pauv ntawm lub hli-rau-hli ua rau nws yooj yim nyeem.
