Kana iwe uchitsvaga nzira yemazuva ano yekuona data, tarisa iyo Excel wachi yekumeso chati. Iyo dial chart yakanyatsogadzirirwa kushongedza dashboard, uye nekuda kwekufanana kwayo nemotokari inomhanya, inodaidzwa zvakare kuti Speedometer chart.
Chiso chewachi chati chakanakira kuratidza mazinga ekuita uye zviitiko zvakakosha.
Mbichana mbichana:
- Gadzira chikamu mutafura dhayira (zvinoreva kuti dial) uye muchitokisi chayo chekutanga tinopinda kukosha 180. Zvadaro tinopinda muhuwandu hwemashoko anoratidza kushanda, kutanga nemaitiro asina kunaka. Aya makoshero anofanira kunge ari chidimbu che180. Kana iyo yekutanga data inoratidzwa senge muzana, saka inogona kushandurwa kuve yakakwana kukosha nekuwanza ne 180 uye kupatsanura ne100.
- Simbisa chikamu dhayira uye gadzira donut chati. Kuti uite izvi, pane tab Insert (Isa) muchikamu Mifananidzo (Machati) tinya museve mudiki pakona yekurudyi (inoratidzwa pamufananidzo uri pazasi).
- A dialog box richavhura Isa chati (Isa chati). Vhura tab Madhayagiramu ese (All Charts) uye mune menyu kuruboshwe, tinya Circular (Pie). Sarudza kubva pane akakurudzirwa subtypes mhete (Donut) chati uye tinya OK.
- Chati ichaonekwa papepa. Kuti iite senge dial chaiyo, iwe uchada kushandura zvishoma kutaridzika kwayo.
- Sarudza poindi 2 mune data series dhayira. Mupanera Data point format (Format Data Point) shandura parameter Rotation angle yechikamu chekutanga (Angle yeChikamu Chekutanga) на 90 °.
- Sarudza poindi 1 uye mupanera Data point format (Format Data Point) shandura kuzadza kuti Kwete zadza (Hapana Kuzadza).
Chati yacho yave kuita kunge dial chart. Inoramba ichiwedzera museve kune dial!
Kuti uwedzere museve, unoda imwe chati:
- Isa koramu woisa kukosha 2. Pamutsetse unotevera, isa kukosha 358 (360-2). Kuita kuti museve uwedzere, wedzera kukosha kwekutanga uye kuderedza yechipiri.
- Sarudza iyo column uye gadzira pie chati kubva mairi nenzira imwechete sezvakatsanangurwa pakutanga muchinyorwa chino (nhanho 2 uye 3) nekusarudza. Circular chati panzvimbo Annular.
- Mune mapaneru Data series format (Format Data Series) shandura kuzadzwa kwechikamu chikuru chechati kuti Kwete zadza (Kwete Kuzadza) uye muganhu hapana muganhu (Hapana Border).
- Sarudza chikamu chidiki chechati chichaita semuseve wochinja muganhu kuti hapana muganhu (Hapana Border). Kana iwe uchida kushandura ruvara rwemuseve, sarudza sarudzo kuzadza kwakasimba (Solid Zadza) uye yakakodzera ruvara.
- Dzvanya kuseri kwenzvimbo yechati uye mupaneru inoonekwa, shandura kuzadza kuti Kwete zadza (Hapana Kuzadza).
- Dzvanya chiratidzo chechiratidzo ndinoiitawo (+) yekukurumidza kuwana menyu Chati zvinhu (Chati Elements) uye usatarise mabhokisi ari padyo ne muzvinambiri (Legend) uye zita (Chinyorwa cheChati).
- Tevere, isa ruoko pamusoro peiyo dial uye itenderedze kune yaunoda chinzvimbo uchishandisa parameter Rotation angle yechikamu chekutanga (Angle yeChikamu Chekutanga).
Ready! Tangogadzira chati yekutarisa kumeso!