Ma chart mu Excel okhala ndi data zosiyanasiyana: cholinga, mitundu, momwe amamangira

Malangizo, zidule, ndi njira zosinthira mawonekedwe a ma chart mu Microsoft Excel.

Zida zopangira ma chart mu Microsoft Excel 2010 ndi 2007 ndizabwinoko pamawonekedwe ndi magwiridwe antchito kuposa zomwe zidapezeka m'mitundu yakale ya Excel. Ngakhale ma graph amawoneka bwino, sizinthu zonse zomwe zimagwiritsidwa ntchito kuti ziwonjezere ntchito zomwe zimawonekera nthawi yomweyo. Nkhani yayifupi iyi ili ndi maupangiri othandiza, zidule ndi njira zopangira ma chart mu Excel zomwe zingapangitse kuti ntchito yanu ikhale yabwino.

kudzaza chitsanzo

Kusintha kwa Microsoft Office 2010 ndikutha kugwiritsa ntchito tchati chodzaza ndi grayscale. Kuti muwone izi zikugwira ntchito, onetsani chithunzicho, sankhani "Zida za Tchati” → "Layout tab" ndikusankha kusintha kuchokera pamndandanda wotsitsa pamwamba kumanzere kwa riboni. Sankhani “Sankhani Format (pamunsi pa riboni) ndikusankha "Dzazani" → "Pattern fill". Kuti mupeze tchati chakuda ndi choyera, ikani mtundu wakutsogolo kukhala wakuda ndi mtundu wakumbuyo kukhala woyera, ndikusankha mtundu wodzaza pamndandandawo. Bwerezani masitepe a template ina. Simukuyenera kugwiritsa ntchito zakuda ndi zoyera, yesani ma templates osiyanasiyana kuti muwonetsetse kuti matchatiwo ndi omveka akasindikizidwa zakuda ndi zoyera kapena kukopera zakuda ndi zoyera.

Ma templates atha kugwiritsidwa ntchito kudzaza tchati mu Excel 2010 kuti athe kusindikizidwa mwakuda ndi zoyera kapena kukopera zakuda ndi zoyera.

Sungani ma chart a Excel ngati chithunzi

Mutha kusunga tchati ngati chithunzi kuchokera ku Excel kuti mugwiritse ntchito pazolemba zina monga malipoti kapena intaneti. Kuti tisunge tchati ngati chithunzi, njira yosavuta ndiyo kupanga tchati chomwe chili patsambalo kuti chikhale chachikulu. Kuti muchite izi, muyenera kutsatira njira iyi: file → Sungani monga, sankhani njira yosungira fayilo yomaliza ndi mndandanda wotsitsa "Sungani mtundu” sankhani tsamba (*.htm;*.html), lowetsani dzina la fayilo yatsopano ndikudina batani Sungani.

Chotsatira chake, tsambalo limasinthidwa kukhala fayilo ya html, ndipo popeza mafayilo a html sangakhale ndi zithunzi, tchaticho chimasungidwa padera ndikugwirizanitsidwa ndi fayilo ya html. Tchaticho chidzasungidwa mufoda yomwe fayilo ya html idasungidwa. Chifukwa chake ngati fayiloyo idatchedwa Sales.htm, ndiye kuti zithunzizo zitha kukhala mufoda yotchedwa sales_files. Zithunzizo zimasungidwa ngati fayilo yosiyana ya PNG. Ngati chithunzi ndi fayilo iyi ya Excel ikufunikabe kuti igwire ntchito, iyeneranso kusungidwa padera.

Tchaticho chikhoza kusungidwa ngati fayilo yojambula ngati mungafunikire pulojekiti ina.

Kuphatikizika kwa mizere ndi kusintha kwapambali

Maonekedwe a tchati akhoza kusinthidwa mwa kusintha m'lifupi mwa mizere ndi mipata ya mbali pakati pawo. Kuti musinthe kuphatikizika kwa matchati awiri kapena kusintha mtunda pakati pawo, dinani kumanja pamzere uliwonse pa tchati ndikudina "Data Series Format". Gwiritsani ntchito mawonekedwe a Mizere Yodutsana kuti mugawe mizere kapena kuphatikiza mizere pokokera chotsetsereka ku Gap kapena Overlap.

Choncho, mtunda wa pakati pa mizereyo umasinthidwa kuti ukhale pafupi kapena kutali. Ngati pali mitundu iwiri ya deta mu tchati, ndipo imayenera kukhala pamwamba pa wina ndi mzake, ndipo mzere wachiwiri uyenera kukhala wapamwamba pa yoyamba, ndiye kuti dongosolo la kupanga tchati likusintha. Choyamba, kuphatikizika kofunikira kumakhazikitsidwa. Kenako dinani kumanja kuti musankhe mndandanda wazinthu ndikusankha "Sankhani data". Kenaka, mzere wa 1 umasankhidwa ndikusunthira ku mzere wa 2. Mwa kusintha ndondomeko ya matebulo motere, deta yaying'ono ikhoza kuwonetsedwa kutsogolo kwa zazikulu.

Big Data Series

Pokonzekera deta malinga ndi masiku, mndandanda wa deta nthawi zambiri umakhala wopapatiza kwambiri. Yankho la funsoli ndikuwunikira x-axis (yopingasa axis) ya tchati cha Excel, dinani kumanja ndikusankha mtundu wa axis. Mukasankha zosankha za axis, muyenera dinani pa axis kuti musankhe. Mwanjira imeneyi, kukula kwa mzere womwe mukufuna kutha kusinthidwa. Kuphatikiza pa mizere, mutha kusintha mtunda pakati pawo.

Kukonzekera pa Axis Yachiwiri

Pokonzekera deta yaying'ono, monga maperesenti, omwe ali pafupi ndi deta yaikulu, monga mamiliyoni, maperesenti adzatayika ndipo sawoneka. Vutoli limathetsedwa popanga tchati chamaperesenti pamagawo osiyanasiyana. Kwa ichi, chithunzi chimasankhidwa ndi tabu "Kugwira ntchito ndi ma chart", tabu yasankhidwa Kuyika, yomwe ili kumtunda kumanzere. Mukufuna kusankha mizere yomwe sikuwoneka. Kenako dinani batani "Kusankha Format", yomwe idzawonekere pansipa, ndiye mu gulu "Row Options" sankhani "Sekondale Axis" ndi kutseka zenera. Popanda kusuntha chinthu chosankhidwa, sankhani "Kugwira ntchito ndi ma chart", ndiye - tabu Wopanga, kenako sankhani "Sintha Mtundu wa Tchati".

Tsopano mutha kusankha mtundu wina wa tchati, monga Mzere. Chifukwa chakuti mndandanda wasankhidwa umene udzangogwira ntchito pa mpambowo osati pa tchati chonsecho, zotsatira zake zimakhala tchati chophatikizidwa, monga tchati cha bar chokhala ndi tchati cha mzere pamwamba pake. Tchati chikuwoneka bwino ndipo chimakhala chosavuta kuwerenga ngati mawu omwe ali pa axis ake akugwirizana ndi mtundu wa gawo la tchati lomwe lili ndi deta. Choncho, ngati pali mizere yobiriwira, ndi bwino kulembera malemba ogwirizana nawonso mumtundu wobiriwira, ndipo mzere wofiira udzawonetsedwa wofiira pa axis yake.

Pangani ma combo chart

Ogwiritsa ntchito a Microsoft Excel sadziwa nthawi yomweyo kuti imatha kupanga ma combo chart; komabe, izi ndizosavuta kuchita. Kuti muchite izi, deta imasankhidwa ndipo mtundu woyamba wa tchati umamangidwa, mwachitsanzo, mzere wa mzere. Kenako mndandanda umasankhidwa womwe uyenera kuwonetsedwa mwanjira ina, mwachitsanzo, pogwiritsa ntchito tchati cha mzere, ndi "Kugwira ntchito ndi ma diagram" → tabu "Constructor" → "Sintha Mtundu wa Tchati" ndipo mtundu wa tchati wachiwiri umasankhidwa. Mitundu ina ya matchati sangathe kuphatikizidwa pazifukwa zomveka, monga mizere iwiri, koma mizere ndi mizere imagwirira ntchito limodzi.

Pangani ma chart a Excel zokha

Ngati muli ndi deta yomwe idzakula pakapita nthawi, mukhoza kupanga tchati kuti ikule kwambiri pamene deta yowonjezera ikuwonjezeredwa ku malo osungiramo deta. Kuti muchite izi, deta iyenera kusinthidwa ngati tebulo. Kuti muchite izi, deta yomwe yalowetsedwa kale imasankhidwa, ndi pa tabu "Pofikira" ntchito yasankhidwa "Format as table". Tsopano, chifukwa deta imapangidwa ngati tebulo, mukamapanga tchati pa data ya tabular, kuwonjezera zambiri patebulo kudzakulitsa tchaticho.

Mitu ya Smart Chart

Mutu wa tchati ukhoza kukokedwa kuchokera kumodzi mwamaselo omwe ali patsamba la Excel. Choyamba, mutu wa tchati wawonjezedwa mu "Kugwira ntchito ndi ma diagram" → Tab → "Tchati Mutu" ndipo imayikidwa, mwachitsanzo, pamwamba pa chithunzicho. Selo la mutu wa tchati limasankhidwa, kenako cholozera chimasunthidwa ku kapamwamba kapamwamba ndipo zolozerazo zimalowetsedwa muselo lomwe lili ndi data yomwe idzakhala mutu wa tchati. Ngati mutu wa tchati uyenera kukhala wofanana ndi pepala, selo la D5 pa pepala loyamba liyenera kukhala lopanda kanthu. Tsopano, zonse zimene zili mu selolo zikasintha, mutu wa tchatiwo umasinthanso.

Kusintha kwa Mtundu wa Tchati cha Excel

Pama chart omwe ali ndi mtundu umodzi wa data, mutha kuwona kuti Excel imapanga mitundu yonse yamitundu yofanana. Izi zitha kusinthidwa podina pamzere ndikudina kumanja, kenako muyenera kusankha tabu. "Format Data Series", Kenako - "Kudzaza". Ngati tchati chikuwonetsa mndandanda umodzi wokha wa data, mutha kusankha njirayo “Madontho Amitundu”.

Inde, mutha kusankha nthawi zonse mndandanda wazinthu, dinani kumanja ndikusankha "Data Point Format"ndiyeno ikani mtundu uliwonse wa malo a datawo.

Kuwongolera ma nulls ndi data yosowa

Pakakhala ziro zowerengera kapena zosowa pa tchati, mutha kuwongolera mawonedwe a ziro posankha mzere wa tchati, ndiye - "Kugwira ntchito ndi ma chart" → tabu "Constructor" → "Sankhani data" → "Maselo obisika ndi opanda kanthu". Apa mutha kusankha ngati ma cell opanda kanthu akuwonetsedwa ngati mipata kapena ziro, kapena ngati tchati ndi tchati cha mzere, kaya mzerewo uyenera kuyenda kuchokera pamfundo kupita kumalo m'malo mwa mtengo wopanda kanthu. Pambuyo posankha deta yofunikira, zosinthazo zimasungidwa mwa kukanikiza batani "CHABWINO".

Zindikirani. Izi zikugwiranso ntchito pazosowa, osati zopanda pake.

Kupanga Discontiguous Data

Kuti mukonze deta yomwe ilibe mzere wotsatira, gwiritsani fungulo la Ctrl mutatha kusankha deta pamtundu uliwonse. Mukasankha mtundu, tchati chimapangidwa kutengera zomwe mwasankha.

Sungani tchati ngati template

Kuti musunge tchati ngati template kuti igwiritsidwenso ntchito, mumayamba kupanga ndikusintha mawonekedwe omwe mukufuna tchati. Sankhani tchati, dinani "Kugwira ntchito ndi ma chart", ndiye tabu imatsegulidwa "Constructor" ndipo dinani batani "Sungani Monga Template". Muyenera kuyika dzina la tchati ndikudina Save. Mtunduwu ukhoza kugwiritsidwa ntchito pazithunzi zina pogwiritsa ntchito template yosungidwa popanga chithunzi chatsopano kapena kusintha chomwe chilipo kale. Kuti mugwiritse ntchito template yosungidwa, muyenera kusankha tchati. Kuti musankhe, tsatirani unyolo: "Kugwira ntchito ndi ma chart”→ “Mlangizi → Sinthani mtundu wa tchati → Pantchito. Kenako sankhani template yomwe idapangidwa kale ndikudina batani "Chabwino".

Malangizo a charting awa ndi zidule zimakuthandizani kupanga ma chart okongola mwachangu komanso mwaluso mu Excel 2007 ndi 2010.