Speedometer chati musanganiswa we donut uye pie chati. Iyo chati inoita seizvi:
Kugadzira chati yekumhanyisa mota:
- Simbisa huwandu H2:I6.
- Pa Advanced tabo Insert (Isa) muchikamu Mifananidzo (Machati) tinya Madhayagiramu ese (Mamwe Machati) uye sarudza Annular (Donut).
- Tevere, iwe unofanirwa kusarudza imwe neimwe data poindi uye shandisa iwo murairo Selection Format (Format kusarudzwa) gadzirisa kuzadzwa kwechimwe nechimwe chinhu. Teerera kune muenzaniso unoratidzwa pazasi:
- Kune akatevedzana datadonut» Kuzadza kunogadzirirwa sezvinotevera: zvikamu zvitatu zvekutanga zvine ruvara rwakasiyana rwekuzadza (tsvuku, yero uye yakasvibirira yakasvibirira), uye doti rechina harina kuzadza.
- Kune akatevedzana dataFloor» - yekutanga uye yechitatu pfungwa hadzina kuzadzwa, uye yechipiri (diki chikamu) yakazadzwa nedema.
Data Series "donut"Kana kuti"Floor»inogona kusarudzwa pane tab Framework (Format). Unogona kushandisa makiyi emiseve kufamba kubva pane imwe data uchienda kune imwe.
- Sarudza nhevedzano yedata "donut”, dzvanya bhatani Selection Format (Format Sarudzo) uye pinda iyo parameter Rotation angle yechikamu chekutanga (Angle) kukosha 270 madhigirii.
- Sarudza dhiyagiramu, tinya-kurudyi pairi, mune yemukati menyu, tinya Chart Area Format (Format Chart Area) uye yekuzadza uye sarudzo dzemuganho, sarudza zvichiteerana Kwete zadza (Kwete mwanakomana) uye hapana mitsetse (Hapana mutsetse).
- Dzima ngano. Mhedzisiro:
- Sarudza nhevedzano yedata "Floor' uye shandura mhando yechati yeiyi nhevedzano kuti Circular (Pie).
- Sarudza nhevedzano yedata "Floor”, dzvanya bhatani Selection Format (Kusarudzwa kwefomati), yeparameter Angle yekutenderera yekutanga zvikamu (Angle) isa kukosha kwe270 madhigirii uye sarudza yakatevedzana yekuvaka maitiro diki axis (secondary axis).Chigumisiro. Data Series Plot "Floor” inosanganisira:
- isingaonekwi isina ruvara chikamu inoenderana nekukosha 75,
- dema chikamu-museve unoenderana kukosha 1
- uye imwe nzvimbo isina ruvara inoenderana nekukosha 124.
- Kushandisa control kaunda (Spin bhatani) shandura kukosha kwesero I3 kubva 75 kusvika 76. Pa girafu ye data series "Floor» shanduko ichaitika: yekutanga isina ruvara chikamu icharatidza kukosha 76; yechipiri dema icharamba yakaenzana ne1; chikamu chechitatu chisina ruvara chicharatidza kukosha 200-1-76 = 123. Kutenda kune formula muchitokisi I3 huwandu hwezvikamu zvitatu izvi huchagara huri mazana maviri.
