A cikin wannan misali, za mu nuna muku yadda ake ƙirƙirar ginshiƙi na ma'aunin zafi da sanyio a cikin Excel. Zane na ma'aunin zafi da sanyio yana kwatanta matakin cimma burin.
Don ƙirƙirar ginshiƙi na ma'aunin zafi da sanyio, bi waɗannan matakan:
- Hana tantanin halitta B16 (dole ne wannan tantanin halitta kada ya taɓa wasu sel masu ɗauke da bayanai).
- A kan Babba shafin Saka (Saka) danna maɓallin Saka histogram (Shafi) kuma zaɓi Histogram tare da rukuni (Rukunin Rumbun).
Sakamako:
Na gaba, saita ginshiƙi da aka ƙirƙira:
- Danna kan Labarin da ke gefen dama na zanen kuma danna maɓallin akan madannai share.
- Canja faɗin ginshiƙi.
- Danna dama akan ginshiƙin ginshiƙi, a cikin mahallin menu zaɓi Tsarin bayanai (Format Data Series) da kuma siga Tsare gefe (Nisa Nisa) saita zuwa 0%.
- Danna-dama akan sikelin kashi akan ginshiƙi, a cikin mahallin menu zaɓi Tsarin Axis (Format Axis), saita ƙananan dabi'u zuwa 0 kuma matsakaicin daidai yake 1.
- latsa Close (Kusa).
Sakamako: