Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel

Ngati mukufuna njira yamakono yowonera deta, yang'anani tchati cha nkhope ya wotchi ya Excel. Tchati choyimbacho chimapangidwa kuti azikongoletsa dashboard, ndipo chifukwa chofanana ndi liwiro lagalimoto, imatchedwanso tchati cha Speedometer.

Tchati cha nkhope ya wotchi ndi yabwino kuwonetsa magwiridwe antchito ndi zochitika zazikulu.

Gawo ndi gawo:

  1. Pangani ndime mu tebulo Sakani (zomwe zimatanthawuza kuyimba) ndipo mu selo yake yoyamba timalowetsa mtengo wa 180. Kenaka timalowetsa deta yomwe ikuwonetsa bwino, kuyambira ndi makhalidwe oipa. Izi ziyenera kukhala kachigawo kakang'ono ka 180. Ngati deta yoyambirira ikuwonetsedwa ngati peresenti, ndiye kuti ikhoza kusinthidwa kukhala mfundo zenizeni mwa kuchulukitsa ndi 180 ndikugawa ndi 100.
  2. Onetsani gawo Sakani ndi kupanga tchati cha donut. Kuti muchite izi, dinani pa tabu Ikani (Ikani) mu gawo Zithunzi (Matchati) dinani kamuvi kakang'ono kumunsi kumanja kwa ngodya (yosonyezedwa pachithunzi pansipa).Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel
  3. Bokosi la zokambirana lidzatsegulidwa Ikani tchati (Lowetsani tchati). Tsegulani tabu Zithunzi zonse (Ma chart Onse) ndi menyu kumanzere, dinani Mzunguli (Pie). Sankhani kuchokera kumagulu ang'onoang'ono omwe aperekedwa mphete (Donut) tchati ndikudina OK.Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel
  4. Chojambulacho chidzawonekera pa pepala. Kuti iwoneke ngati kuyimba kwenikweni, muyenera kusintha pang'ono mawonekedwe ake.Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel
  5. Sankhani mfundo 2 mu data series Sakani. Mu gulu Mtundu wa data point (Format Data Point) sinthani parameter Kuzungulira kozungulira kwa gawo loyamba (Angle of First Slice) pa 90 °.Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel
  6. Sankhani mfundo 1 ndi pa panel Mtundu wa data point (Format Data Point) sinthani kudzaza kukhala Palibe kudzaza (Palibe Kudzaza).Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel

Tchati tsopano zikuwoneka ngati dial chart. Zimatsalira kuwonjezera muvi pa kuyimba!

Kuti muwonjezere muvi, mufunika tchati china:

  1. Lowetsani ndime ndikuyika mtengo 2. Pamzere wotsatira, lowetsani mtengo 358 (360-2). Kuti muvi ukulitse, onjezani mtengo woyamba ndikuchepetsa wachiwiri.
  2. Sankhani ndime ndikupanga tchati cha chitumbuwa kuchokera momwemonso momwe tafotokozera m'nkhaniyi (masitepe 2 ndi 3) posankha. Mzunguli tchati m'malo mwake Chakale.
  3. Mu mapanelo Mawonekedwe a mndandanda wa data (Format Data Series) sinthani kudzazidwa kwa gawo lalikulu la tchati kukhala Palibe kudzaza (Palibe Kudzaza) ndi malire palibe malire (Palibe Border).
  4. Sankhani gawo laling'ono la tchati lomwe likhala ngati muvi ndikusintha malire palibe malire (Palibe Border). Ngati mukufuna kusintha mtundu wa muvi, sankhani njirayo kudzaza kolimba (Solid Dzazani) ndi mtundu woyenera.
  5. Dinani kumbuyo kwa malo a tchati ndi pagawo lomwe likuwonekera, sinthani kudzaza Palibe kudzaza (Palibe Kudzaza).
  6. Dinani chizindikiro chizindikiro more (+) kuti mupeze menyu mwachangu Ma chart a zinthu (Tchati Elements) ndi kuchotsa cholembera mabokosi pafupi Bakuman (Nthano) ndi dzina (Mutu wa Tchati).Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel
  7. Kenako, ikani dzanja pamwamba pa kuyimba ndikuzungulirani pamalo omwe mukufuna pogwiritsa ntchito chizindikiro Kuzungulira kozungulira kwa gawo loyamba (Ngongole ya Gawo Loyamba).Dabwitsani anzanu omwe ali ndi tchati cha nkhope ya wotchi mu Excel

Okonzeka! Tangopanga tchati cha nkhope ya wotchi!

Siyani Mumakonda