Dhiyagiramu "Chirongwa-Chokwadi"

Maneja asingawanzo mukuita kwake haana kutarisana nekudikanwa kwekuona mhedzisiro inowanikwa mukuenzanisa neiyo yakarongwa pakutanga. Mumakambani akasiyana, ndakaona akawanda machati akafanana anonzi "Plan-Fact", "Actual vs Budget", nezvimwewo. Dzimwe nguva anovakwa seizvi:

Iko kusagadzikana kwemufananidzo wakadaro ndeyekuti muoni anofanira kuenzanisa chirongwa uye chokwadi makoroni ari maviri, achiedza kuchengeta mufananidzo wose mumusoro wake, uye histogram pano, mumaonero angu, haisi iyo yakanakisisa sarudzo. Kana isu tichizovaka tarisiro yakadai, saka zvinonyanya kuoneka kushandisa magirafu echirongwa uye chokwadi. Asi isu takatarisana nebasa rekuona paviri kuenzanisa mapoinzi enguva imwe chete uye kuratidza musiyano uri pakati pawo. Ngatiedzei mamwe maitiro anobatsira eizvi.

Nzira 1. Up-down mabhandi

Aya ndiwo marectangles ekuona anobatana ari maviri mapoinzi echirongwa uye chokwadi magirafu padhiyagiramu yedu. Uyezve, ruvara rwavo runoenderana nekuti takapedza chirongwa here kana kuti kwete, uye saizi inoratidza kuti yakawanda sei:

Mabhandi akadaro anosanganisirwa pane tab Muvaki – Wedzera Chart Element – ​​Kumusoro/Kudzika Mabhendi (Dzaini - Wedzera Chart Element - Kumusoro/Kudzika Mabhara) muExcel 2013 kana pane tab Kurongeka – Advance-Decrement Bars (Kurongeka - Up-Down Bars) muExcel 2007-2010. Nekusagadzikana vanozove vatema uye chena, asi iwe unogona nyore kushandura ruvara rwavo nekudzvanya-kurudyi pavari uye nekusarudza murairo. Kumusoro/Kudzika Mabhendi Format (Format Up/Down Bars). Ini ndinokurudzira zvikuru kushandisa translucent kuzadza, nekuti. mutsara wakasimba unovhara magirafu ekutanga ivo pachavo.

Zvinosuruvarisa, hapana nzira iri nyore yakavakirwa-mukati yekugadzirisa hupamhi hwemaronda - nokuda kweizvi uchafanira kushandisa zvishoma zvishoma.

1. Simbisa mufananidzo wakagadzirwa
2. Dzvanya nzira yekudimbudzira kiibhodhi Alt + F11kuti upinde muVisual Basic Editor
3. Dzvanyiridza tsananguro ye keyboard CTRL+Gkuvhura iyo yakananga yekuraira yekupinda uye debug pani Pakarepo
4. Kopa uye unamate murairo unotevera ipapo: ActiveChart.ChartGroups(1).GapWidth = 30 uye tigoshingairira pinda:

Ehe, parameter (30) inogona kuridzwa kutenderedza kuti uwane hupamhi hwaunoda kuyedza.

Nzira 2. Chati ine kuzadza nzvimbo pakati pechirongwa nemitsara yechokwadi

Iyi nzira inosanganisira kuzadza kwekuona (zvinogoneka nekucheka, semuenzaniso) yenzvimbo pakati pechirongwa uye chokwadi magirafu:

Zvinoshamisa, handizvo here? Ngatiedzei kuita izvi.

Kutanga, wedzera imwe koramu patafura yedu (ngatiidaidze, ngatiti, Kusiyana), kwatinoverenga mutsauko pakati pechokwadi uye chirongwa sefomula:

Zvino ngatisarudze makoramu ane mazuva, kuronga uye musiyano panguva imwe chete (kubata Ctrl) uye gadzira dhayagiramu nenzvimbo dzine kuunganidzwakushandisa tab Insert (Isa):

Izvo zvabuda zvinofanira kutarisa chimwe chinhu chakadai:

Nhanho inotevera ndeyekusarudza mitsara urongwa и chokwadi, zvikopa (Ctrl + C) uye wedzera kudhayagiramu yedu nekuisa (Ctrl + V) - mune yedu "sandwich muchikamu" maviri matsva "matanho" anofanira kuoneka pamusoro:

Zvino ngatichinjei rudzi rwechati yezvikamu zviviri izvi zvakawedzerwa kuita girafu. Kuti uite izvi, sarudza mutsara wega wega, penya-kurudyi pairi uye sarudza murairo Shandura rudzi rwechati kune dzakatevedzana (Shandura Series Chart Type). Mune shanduro dzekare dzeExcel 2007-2010, unogona kusarudza rudzi rwechati yaunoda (Grafu ine mamakisi), uye muExcel 2013 itsva bhokisi renhaurirano richaonekwa nemitsara yese, apo mhando yaidiwa inosarudzwa pamutsara wega wega kubva kune ekudonha-pasi zvinyorwa:

Mushure mekunge mavharidza OK tichaona mufananidzo wakatofanana nezvatinoda:

Zviri nyore kufunga kuti zvinongosara chete kusarudza nzvimbo yebhuruu uye shandura iyo yekuzadza ruvara kuti ijeke Kwete zadza (Hapana Kuzadza). Zvakanaka, uye uunze kupenya kwakawanda: wedzera zvinyorwa, zita, bvisa zvisina basa zvinhu mungano, nezvimwe.

Mukuona kwangu, izvi zviri nani kudarika makoramu, kwete?

• Maitiro ekukurumidza kuwedzera data nyowani kune chati nekukopa
• Bullet chati yekuratidza KPI
• Vhidhiyo yekudzidzisa pakugadzira chirongwa cheGantt chati muExcel