Yuav Paub
- Xaiv yam tsawg kawg ob kab lossis kab ntawm cov ntaub ntawv hauv Excel. Ces, xaiv Insert.
- In Charts, xaiv qhov Scatter (X, Y) lossis Daim Npav Npauj Npaim cov ntawv qhia zaub mov poob. Xaiv Ntau Scatter Charts thiab xaiv cov kab kos duab. Xaiv OK.
- Excel ntxig rau daim ntawv. Xaiv daim duab qhia thiab hloov kho los ntawm nias + (ntxiv) los tso saib cov ntsiab lus koj tuaj yeem thov lossis hloov pauv.
Kab lus no piav qhia yuav ua li cas los tsim cov phiaj xwm tawg hauv Excel rau Windows thiab Mac computers. Nws kuj suav nrog cov ntaub ntawv rau Android thiab iOS pab kiag li lawm. Cov lus qhia siv rau Excel 2019, 2016, 2013, 2010, Excel 2016, 2011 rau Mac, Excel 365, thiab Microsoft Excel ntawm Android thiab iOS.
Yuav ua li cas los tsim daim ntawv Scatter hauv Excel ntawm Windows lossis macOS
Hauv Excel, ib daim ntawv qhia tawm qhia cov ntaub ntawv cov ntsiab lus nyob ntawm kev tswj xyuas nyob rau ntawm x-axis thiab y-axis. Scatter charts yog qee zaum hu ua X thiab Y kab kos, cov phiaj xwm tawg, cov kab kos, lossis cov kab kos tawg.
Ib daim ntawv faib ua ke pab koj sib piv khub ntawm qhov tseem ceeb thiab nkag siab txog kev sib raug zoo ntawm ob qhov sib txawv. Txhawm rau tsim cov phiaj xwm tawg hauv Excel ntawm lub khoos phis tawj lossis lub desktop, ua raws cov kauj ruam no.
-
Tshawb xyuas koj cov ntaub ntawv teev kom paub tseeb tias koj muaj tsawg kawg ob kab (lossis kab) ntawm cov ntaub ntawv. Qhov zoo tshaj plaws, thawj lub xovtooj ntawm txhua ntu yuav muaj cov ntawv sau uas piav qhia cov lej uas ua raws, xws li "Mileage of Car" lossis "Cov Nqi Them Nyiaj Txhua Xyoo".
Image -
Nrog koj tus nas, xaiv lub xovtooj ntawm sab laug sab saud ntawm cov ntaub ntawv koj xav teev, ces luag tus cursor mus rau sab xis ntawm tes ntawm cov ntaub ntawv teeb tsa los xaiv nws.
Image -
Xaiv Insert.
Image -
In Charts, xaiv tus Scatter (X, Y) lossis Daim Ntawv Ua npuaspoob.
Image -
Xaiv Ntau Scatter Charts nyob rau hauv qab ntawm cov ntawv qhia zaub mov.
Image -
Xaiv kab ntawv Scatter kev xaiv koj nyiam. (Scatter, Scatter nrog Smooth Lines thiab Markers, Scatter nrog Smooth Lines, Scatter with Straight Lines and markers, Scatter with Straight Lines, npub, los yog 3-D npuas)
Image -
Xaiv seb koj puas xav sib piv ob kab ntawm cov ntaub ntawv, lossis siv ob kab ua x- thiab y-axis ntsuas, raws li. Xaiv tus qauv kab ntawv, ces xaiv OK.
Image -
Excel tam sim no yuav tsum tau ntxig ib daim ntawv rau hauv koj daim ntawv nthuav qhia uas qhia koj cov ntaub ntawv. Yog tias koj daim ntawv teev npe, axis daim ntawv lo, thiab lwm cov ntsiab lus raws li koj xav tau, koj tuaj yeem nres ntawm qhov no. Txawm li cas los xij, feem ntau, koj yuav tsum tau kho ib lossis ntau daim ntawv qhia.
Image -
Nias (lossis kais) ntawm qhov chaw dawb huv hauv daim duab los xaiv daim duab.
Image -
Tom ntej no, kho cov kab ntawv qhia cov kev xaiv. Xaiv tus + tus yuam sij ntawm ib sab ntawm daim duab los xaiv cov kab ntawv twg tso tawm. Tom ntej no rau txhua lub caij, yog tias koj xaiv lub checkbox, cov khoom yuav tso tawm. Deselect lub checkbox kom nkaum ib lub ntsiab.
Image Cov kab ntawv qhia yuav suav nrog Axes, Axis Titles, daim ntawv npe,Data Labels, Error Bars, Gridlines, Legend , thiabTrendline Xaiv rau sab xis ntawm lub npe lub npe kom pom daim duab peb sab uas tso cai rau kev nkag mus rau cov kev xaiv ntxiv. Piv txwv li, ib sab ntawm Gridlines , koj tuaj yeem pab Primary Major Kab rov tav, Primary Major Vertical , Primary Minor Horizontal, Primary Minor Vertical, or Ntau Options
Nyob rau hauv yuav luag txhua rooj plaub, koj yuav tsum pab Axes, Axis Titles, kab npe, and Gridlines.
-
Yog xav tau, nrog rau daim ntawv xaiv, xaiv Daim Ntawv Qhia (xim txhuam) los kho qhov tsos. Koj tuaj yeem xaiv los ntawm ntau hom kab ntawv sib txawv, nrog rau xaiv cov xim palette ua ntej.
Xwb, koj tuaj yeem nyem ob npaug (lossis kais) ntawm daim ntawv qhia kom kho nws.
Image - Thaum ua tiav, nyem (lossis kais) ib zaug ntawm daim ntawv xaiv nws. Thaum xaiv, koj tuaj yeem txav daim duab nyob qhov twg ntawm daim ntawv tam sim no. Koj tuaj yeem hloov pauv daim duab los ntawm kev xaiv thiab txav ib qho ntawm cov kab kos duab. Koj tseem tuaj yeem siv Ctrl + Clos luam daim ntawv, tom qab ntawd Ctrl + Vlos muab daim ntawv qhia rau lwm qhov hauv koj daim ntawv Excel.
Saib Microsoft cov lus qhia los tsim txhua hom kab kos hauv Microsoft Office ntawm Windows lossis macOS, saib Tsim ib daim ntawv qhia txij thaum pib mus txog qhov kawg.
Yuav ua li cas los tsim daim ntawv Scatter hauv Excel ntawm Android lossis iOS
Txhawm rau tsim cov phiaj xwm tawg hauv Excel ntawm Android lossis iOS khoom siv, koj yuav tsum tau nruab Microsoft Excel app hauv koj lub xov tooj (Nruab Microsoft Excel ntawm Android lossis Microsoft Excel rau iOS.)
- Raws li ntawm cov khoom siv desktop, tshawb xyuas koj cov ntaub ntawv teeb tsa kom paub tseeb tias koj muaj tsawg kawg ob kab (lossis kab) ntawm cov ntaub ntawv. Qhov zoo tshaj plaws, thawj lub xovtooj ntawm txhua ntu yuav muaj cov ntawv sau uas piav qhia cov lej uas ua raws, xws li "Mileage of Car" lossis "Cov Nqi Them Nyiaj Txhua Xyoo".
- Coj mus rhaub lub xovtooj ntawm sab laug ntawm cov ntaub ntawv koj xav tau daim ntawv qhia, tom qab ntawd rub tus cursor mus rau sab xis ntawm tes ntawm cov ntaub ntawv teeb tsa los xaiv nws. (Denoted los ntawm ib lub voj voog me me.)
-
Ntawm cov khoom siv loj dua, xws li lub ntsiav tshuaj, coj mus rhaub Insert > Charts > X Y (Scatter).
Ntawm cov khoom siv me me, xws li xov tooj, coj mus rhaub cov ntawv qhia zaub mov hauv qab ntawm qhov screen (nws zoo li tus xub taw qhia), tom qab ntawd coj mus rhaub lo lus Tsev.
Image - Tap Insert.
- Scroll down to Chart thiab xaiv.
-
Scroll down thiab xaiv X Y (Scatter).
Image - Xaiv qhov kev xaiv Scatter daim duab koj nyiam.
-
Excel tam sim no yuav tsum tau ntxig ib daim ntawv rau hauv koj daim ntawv nthuav qhia uas qhia koj cov ntaub ntawv. Yog tias koj daim ntawv teev npe, axis daim ntawv lo, thiab lwm cov ntsiab lus raws li koj xav tau, koj tuaj yeem nres ntawm qhov no.
Image
How to adjust a Scatter Chart on a Mobile Device
Txhawm rau kho tus kheej cov ntsiab lus ntawm lub xov tooj ntawm tes, koj yuav tsum tau kos npe rau Microsoft Excel ntawm Android lossis iOS nrog rau Microsoft 365 kev tso npe. (Cov kev xaiv no yuav greyed.) Thaum koj ua tiav, koj yuav tuaj yeem kho cov duab kos nrog cov kauj ruam hauv qab no:
- Coj mus rhaub rau ntawm daim ntawv xaiv nws.
-
Tom ntej, coj mus rhaub rau ntawm cov ntawv qhia zaub mov xws li Layouts, Elements, Colours, lossis Styles kom nkag mus thiab kho ntau yam kab kos.
Image
txheej txheem los tsim cov phiaj xwm tawg ntawm lub xov tooj ntawm tes, laptop, thiab desktop systems yog qhov zoo sib xws. Nkag mus rau koj cov ntaub ntawv, xaiv nws, ntxig ib daim ntawv qhia, tom qab ntawd kho cov ntawv qhia ntxaws. Qhov kev sib tw tseem ua kom paub tseeb tias daim duab tawg yog ib txoj hauv kev tsim nyog rau kev pom koj cov ntaub ntawv, thiab xaiv cov kab kos duab uas qhia tau zoo tshaj plaws rau koj lub ntsiab lus.
