Tsindikani Deta Za Dongosolo ndi Zophatikiza Zapalasitiki za Excel

Excel ili ndi njira zingapo zowonjezerapo zowonjezera ku magawo kapena magawo ena a tchati cha pie zomwe sizikuphatikiza kusintha kapena kukonzanso deta yake. Izi zikuphatikizapo:

• kuphulika kapena kuchotsa chidutswa chosankhidwa kuchokera ku pie yense;
• kuyika imodzi kapena magawo ambiri pogwiritsa ntchito Pie ya tchati;
• kulongosola chimodzi kapena zingapo magawo pogwiritsa ntchito tchati cha Bar .

Kugwiritsira Ntchito Gawo Limodzi la Pie

Kuonjezeranso kugwiritsidwa ntchito pa tchati ya pie yomwe mungathe kusuntha kapena "kuphulika" izi zimachokera pazithunzi zonse zomwe zingathe kuwonetsedwa kumbali yakumanzere ya chithunzi pamwambapa.

Kuti muchite izi:

1. Dinani kamodzi ndi ndondomeko ya ndondomeko pamtanda wa tchati kuti muwonetsetse - mabwalo ang'onoang'ono a mabluu kapena madontho ayenera kuwonetseredwa pafupi ndi nsanamira yapansi;
2. Dinani kachiwiri pa kagawo kamene kakuphulika;
3. Machaputalawa ayenera tsopano kuzungulira chidutswa chimodzi cha chitumbuwa - kuphatikizapo dontho pakati pa tchati;
4. Dinani ndi kukokera ndi pointer la mouse pa chidutswa cha pie, kuchikoka kapena kuchiphwanya icho kunja kwa tchati chonsecho;
5. Kuti musunthire chidutswa chomwe chinaphulika kumalo ake oyambirira, gwiritsani ntchito chotsitsa cha Excel ngati n'kotheka;
6. Ngati simukutero, bweretsani masitepe 1 ndi 2 pamwamba ndikukoka chidutswa ku pie. Icho chidzabwereranso ku malo ake oyambirira.

Kugwiritsa ntchito Pie Yonse

Ngati magawo onse omwe ali pa tchati akuphulika akutanthauza kuti simunasankhe chidutswa chimodzi. Kuti mukonze izi, kwezerani magawo pamodzi ndikuyesera masitepe 2 ndi 3 pamwambapa.

Chidutswa cha Pie ndi Bar of Pie Charts

Njira ina yowonjezerekera kuzinthu zina za tchati cha pie ndi kugwiritsa ntchito chitumbuwa cha tchire kapena tchati cha tchizi m'malo mwa tchati ya pie.

Ngati muli ndi magawo awiri kapena awiri akuluakulu omwe amachititsa tchati cha pie, zomwe zimapangitsa kuti zikhale zovuta kuona zochepa za magawo ang'onoang'ono, sankhani imodzi mwa mitundu ya tchatiyi, yomwe imatsindika magawo ang'onoang'ono pa tchati chachiwiri - mwina tchati chachiwiri kapena ndondomeko yamatabwa yowonjezera, kusankha ndiko kwanu.

Pokhapokha mutasintha, Excel idzaphatikizapo magawo atatu aang'ono kwambiri (magawo a deta ) mu tchati cha pie kapena stack bar.

Kupanga chitumbuwa cha pie kapena galasi la tchati cha pie:

1. Onetsani ma deta osiyanasiyana kuti agwiritsidwe ntchito pa tchati;
2. Dinani ku Insert tab ya riboni ;
3. Mu bokosi la Chitsulo cha riboni, dinani pa chithunzi cha Insert Pie Chart kuti mutsegule masamba omwe akupezeka omwe alipo;
4. Sungani pepala lanu la mouse pamtundu wa tchati kuti muwerenge kufotokoza kwa tchati;
5. Dinani pa pie kapena galasi la tchati cha pie mu gawo la 2-D la Pie la menyu pansi kuti muwonjezere chithunzi pa tsamba.

Zindikirani: Tsambali lakumanzere ndilo tchati chachikulu, ndi tchati chachiwiri chomwe chikuwonekera nthawi zonse. Makonzedwewa sangasinthe.

Mitundu Yotsatila

Kusinthanso pa tchati cha pie yomwe ilipo nthawi zonse kuti ipange tchire kapena tchati cha tchati:

1. Dinani pakanema tchatichi tsopano kuti mutsegule mndandanda wamakono;
2. Mu menyu, dinani pa Tsatanetsatane wa Chati Chakutsatsa kuti muyatse bokosi lachidule la mtundu wa Chati ;
3. Mu bokosi la bokosi, dinani pazithunzi Zonse Zotsatila;
4. Dinani pa Pie kumanja kwamanzere, ndipo dinani pa Pie ya Pie kapena Bar of Pie kumanja kudzanja la bokosi.

Kusintha Chiwerengero cha Mfundo Za Data

Kusintha nambala ya deta (magawo) omwe akuwonetsedwa pa tchati chachiwiri:

1. Dinani pa chidutswa china pa tchati (deta yogwiritsidwa ntchito popanga tchati chachiwiri) kutsegula Format Data Series pane;
2. M'kati, dinani pansi pavivi pansi pa Split Series Mwa kusankha.

Zosankha zokhudzana ndi kusintha chiwerengero cha deta pamndandanda wachiwiri ndi:

• Apatseni mndandanda ndi malo : Makhalidwe abwino mu bokosi lachiwiri , lowetsani chiwerengero cha maudindo kapena magawo omwe akuwonetsedwa mu tchati chachiwiri - 3 osachepera;
• Agawitseni mndandanda wa Mtengo : Makhalidwe ochepa kusiyana ndi bokosi, lowetsani chiwerengero chachikulu kuposa chiwerengero chazing'ono kwambiri chomwe chingawonetsedwe pa tchati chachiwiri;
• Agawitseni mndandanda ndi Peresenti ya mtengo : Makhalidwe ochepa kusiyana ndi bokosi, lowetsani peresenti ya pakati pa 0% ndi 100% - mtengowu umagwirizana ndi peresenti ya mtengo waukulu wa tchati kuti uwonetsedwe pa tchati chachiwiri.