Nkag siab Excel Daim Ntawv Qhia Cov Ntaub Ntawv, Cov Ntsiab Lus, thiab Cov Ntawv Sau

Cov txheej txheem:

Nkag siab Excel Daim Ntawv Qhia Cov Ntaub Ntawv, Cov Ntsiab Lus, thiab Cov Ntawv Sau
Nkag siab Excel Daim Ntawv Qhia Cov Ntaub Ntawv, Cov Ntsiab Lus, thiab Cov Ntawv Sau
Anonim

Cov kab kos thiab cov duab hauv Excel thiab Google Cov Ntawv siv cov ntaub ntawv cov ntsiab lus, cov cim cov ntaub ntawv, thiab cov ntawv sau cov ntaub ntawv kom pom cov ntaub ntawv thiab xa cov ntaub ntawv. Yog tias koj xav tsim cov kab kos muaj zog, kawm seb txhua yam ntawm cov khoom no ua haujlwm li cas thiab siv lawv li cas.

Cov Ntaub Ntawv thiab Lwm Daim Ntawv Qhia Hauv Excel

Data Point: Ib tus nqi nyob rau hauv ib daim ntawv xovtooj ntawm tes npaj rau hauv daim duab lossis duab.

Data Marker: Ib kem, dot, ncuav qab zib, lossis lwm lub cim hauv daim duab sawv cev rau cov ntaub ntawv tus nqi. Piv txwv li, nyob rau hauv ib kab graph, txhua lub ntsiab lus ntawm kab yog cov ntaub ntawv cim sawv cev rau ib tus nqi ntawm cov ntaub ntawv nyob rau hauv ib daim ntawv ntawm tes.

Data Label: Muab cov ntaub ntawv hais txog tus kheej cov ntaub ntawv cim, xws li tus nqi raug kos los ua tus lej lossis ib feem pua. Feem ntau siv cov ntawv sau rau hauv cov kev pab cuam spreadsheet suav nrog:

  • Numeric Values: Muab los ntawm tus kheej cov ntaub ntawv cov ntsiab lus hauv daim ntawv ua haujlwm.
  • Series Names: Qhia cov kab lossis kab ntawm kab ntawv cov ntaub ntawv hauv daim ntawv ua haujlwm. Cov npe series feem ntau yog siv rau kab kab kos, kab kos kab, thiab kab kos.
  • Qeb npe: Qhia tus kheej cov ntaub ntawv cov ntsiab lus hauv ib kab ntawm cov ntaub ntawv. Cov no feem ntau yog siv rau daim duab ncuav qab zib.
  • Percentage Labels: Muab xam los ntawm kev faib cov neeg teb hauv ib qho los ntawm tag nrho cov nqi ntawm koob. Feem ntau cov ntawv lo yog feem ntau siv rau daim duab ncuav qab zib.

Data Series: Ib pawg ntawm cov ntaub ntawv ntsig txog cov ntsiab lus lossis cov cim uas tau piav qhia hauv kab kos thiab duab. Piv txwv ntawm cov ntaub ntawv series suav nrog ib tus kab hauv kab kab lossis kab hauv kab kab. Thaum ntau cov ntaub ntawv series tau npaj rau hauv ib daim ntawv, txhua cov ntaub ntawv series raug txheeb xyuas los ntawm cov xim tshwj xeeb lossis cov qauv duab ntxoov ntxoo.

Tsis yog txhua daim duab suav nrog pawg ntawm cov ntaub ntawv cuam tshuam lossis cov ntaub ntawv series.

Hauv kab lossis kab kab kos, yog tias ntau kab lossis kab ntawv yog tib xim lossis muaj tib daim duab (nyob rau hauv rooj plaub ntawm daim duab), lawv suav nrog cov ntaub ntawv ib zaug.

Pie kab kos feem ntau txwv rau ib kab ntawv ib kab ntawv. Cov ntawv hlais ntawm lub ncuav yog cov ntaub ntawv cim thiab tsis yog cov ntaub ntawv.

kab hauv qab

Thaum koj xav hu xov tooj rau cov ntaub ntawv tshwj xeeb, ua kom nws txawv ntawm lwm pab pawg. Txhua yam koj yuav tau ua yog hloov cov formatting ntawm cov ntaub ntawv marker.

Hloov xim ntawm ib kab ib kab

Xim ntawm ib kab hauv kab ntawv kab lossis ib qho taw qhia hauv kab kab tuaj yeem hloov pauv yam tsis cuam tshuam rau lwm cov ntsiab lus hauv koob. Cov ntaub ntawv cim uas yog xim txawv dua li lwm pab pawg yuav tshwm rau ntawm daim duab.

  1. Xaiv ib cov ntaub ntawv series hauv kab ntawv kab. Tag nrho cov kab ntawm tib xim yog highlighted. Txhua kem nyob ib puag ncig ntawm ciam teb uas suav nrog cov me me ntawm cov ces kaum.
  2. Xaiv kab hauv kab ntawv los hloov kho. Tsuas yog kem ntawd thiaj tseem ceeb.

    Image
    Image
  3. Xaiv lub Format tab.

    Image
    Image

    Thaum xaiv ib daim ntawv qhia, Daim Ntawv Qhia Cov Cuab Yeej tshwm nyob rau hauv kab thiab muaj ob lub tab. Lub Format tab thiab tsim tab.

  4. Xaiv Shape Fill txhawm rau qhib cov ntawv sau xim.

    Image
    Image
  5. In the Standard Colours, xaiv xim koj xav thov.

    Image
    Image

kab hauv qab

Ib leeg ntawm daim ntawv ncuav qab zib feem ntau yog xim sib txawv. Yog li, hais txog ib feem lossis cov ntaub ntawv taw qhia yuav tsum muaj kev sib txawv ntawm cov kab thiab kab kos. Koj tuaj yeem nthuav qhia cov kab kos duab los ntawm kev nthuav tawm ib qho ntawm cov ncuav qab zib los ntawm daim duab.

Ntxiv qhov tseem ceeb nrog daim ntawv qhia ua ke

Lwm qhov kev xaiv rau kev hais txog ntau hom ntaub ntawv hauv ib daim duab yog los tso saib ob lossis ntau hom kab ntawv hauv ib daim ntawv qhia, xws li kab ntawv kab thiab kab kab. Koj tuaj yeem siv txoj hauv kev no thaum cov graphed qhov tseem ceeb sib txawv los yog thaum kos duab sib txawv ntawm cov ntaub ntawv.

Ib qho piv txwv yog climograph lossis huab cua daim duab, uas muab cov ntaub ntawv nag lossis daus thiab kub rau ib qho chaw ntawm ib daim ntawv. Tsis tas li ntawd, kev sib xyaw ua ke lossis combo kab kos yog tsim los ntawm kev npaj ib lossis ntau cov ntaub ntawv series ntawm ib nrab ntsug lossis Y-axis.

Pom zoo: