Cov txheej txheem:

Yuav ua li cas los tsim ib daim duab hauv Excel 2007?
Yuav ua li cas los tsim ib daim duab hauv Excel 2007?

Video: Yuav ua li cas los tsim ib daim duab hauv Excel 2007?

Video: Yuav ua li cas los tsim ib daim duab hauv Excel 2007?
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Hlis ntuj nqeg
Anonim

Tsim ib daim ntawv qhia:

  1. Xaiv daim ntawv koj xav ua haujlwm nrog.
  2. Xaiv cov hlwb uas koj xav tau daim ntawv qhia, suav nrog cov kab npe kab thiab kab ntawv.
  3. Nyem qhov Insert tab.
  4. Hover tshaj txhua qhov kev xaiv Chart hauv qhov Daim duab pab pawg kawm paub ntxiv txog nws.
  5. Xaiv ib qho ntawm cov kev xaiv kab kos.
  6. Xaiv ib hom kab kos los ntawm cov npe uas tshwm.

Tsis tas li cov lus nug yog, koj ua daim duab siv Microsoft Excel li cas?

Yuav Ua Li Cas Ua Graph hauv Excel

  1. Sau koj cov ntaub ntawv hauv Excel.
  2. Xaiv ib qho ntawm cuaj daim duab thiab daim duab xaiv los ua.
  3. Taw qhia koj cov ntaub ntawv thiab 'Ntxig' koj cov duab xav tau.
  4. Hloov cov ntaub ntawv ntawm txhua axis, yog tias tsim nyog.
  5. Kho koj cov ntaub ntawv layout thiab xim.
  6. Hloov qhov loj ntawm koj daim ntawv qhia cov lus dab neeg thiab cov ntawv cim axis.

Ib yam li ntawd, koj kos ib daim duab li cas? Ua ib kab graph tsis nyuaj dhau.

  1. Tsim ib lub rooj. Kos cov x- thiab y-axes ntawm nplooj ntawv.
  2. Sau txhua axis. Yog tias lub sij hawm yog ib qho ntawm cov xwm txheej, nws yuav tsum yog lub hom phiaj ntawm kab rov tav (x) axis.
  3. Ntxiv cov ntaub ntawv. Cov ntaub ntawv rau ib kab kab feem ntau muaj nyob rau hauv ob kab lus sib thooj rau x- thiab y-axes.
  4. Tsim tus yuam sij.

Kuj kom paub, koj ua li cas los tsim ib daim ntawv qhia hauv Excel rau Dummies?

Txhawm rau tsim ib daim ntawv qhia, ua raws li cov kauj ruam no:

  1. Xaiv cov ntaub ntawv kom suav nrog hauv daim duab. suav nrog txhua lub hlwb uas muaj cov ntawv sau uas yuav tsum muaj nyob hauv daim ntawv, ib yam nkaus.
  2. Ntawm Insert tab, nyem ib hom kab kos. (Siv cov nyees khawm hauv pab pawg Charts.)
  3. Nyem qhov subtype koj xav tau.

Yuav ua li cas ua ib daim duab scatter ntawm Excel?

Yuav ua li cas los tsim Scatter Plot hauv Excel

  1. Xaiv cov ntawv ua haujlwm ntau A1: B11.
  2. Ntawm Insert tab, nyem lub XY (Scatter) daim ntawv qhia kab lus.
  3. Xaiv lub Chart subtype uas tsis suav nrog cov kab.
  4. Paub meej tias lub koom haum daim ntawv qhia.
  5. Sau daim ntawv qhia, yog tias tsim nyog.
  6. Ntxiv ib qho trendline los ntawm txhaj rau Add Chart Element menu'sTrendline hais kom ua khawm.

Pom zoo: