{"id":3389,"date":"2024-09-03T13:10:32","date_gmt":"2024-09-03T13:10:32","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=3389"},"modified":"2024-09-03T13:10:32","modified_gmt":"2024-09-03T13:10:32","slug":"how-to-create-a-dashboard-in-excel-lv","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/how-to-create-a-dashboard-in-excel-lv\/","title":{"rendered":"K\u0101 programm\u0101 Excel izveidot inform\u0101cijas paneli"},"content":{"rendered":"<p>Ja j\u016bsu Excel lap\u0101s ir daudz datu, varat izveidot interakt\u012bvu inform\u0101cijas paneli, kas \u013cauj \u0113rti p\u0101rvald\u012bt \u0161os datus. Inform\u0101cijas panel\u012b ir apkopota galven\u0101 inform\u0101cija, lai j\u016bs var\u0113tu \u0101tri un vien\u0101 mirkl\u012b ieg\u016bt nepiecie\u0161amo inform\u0101ciju. Pirmk\u0101rt, jums ir j\u0101izlemj, k\u0101du inform\u0101ciju v\u0113laties r\u0101d\u012bt inform\u0101cijas panel\u012b. P\u0101rskatiet savus datus un izlemiet, ko iek\u013caut inform\u0101cijas panel\u012b, k\u0101 ar\u012b to, k\u0101 par\u0101d\u012bt \u0161o inform\u0101ciju. Varat izv\u0113l\u0113ties att\u0113lot to k\u0101 l\u012bniju diagrammas, sektoru diagrammas, izkliedes diagrammas vai kaut ko citu.<\/p>\n<p>Kad esat izl\u0113mis, k\u0101dus datus iek\u013caut un k\u0101 tos par\u0101d\u012bt inform\u0101cijas panel\u012b, ir pien\u0101cis laiks tos sagatavot. Datu sagatavo\u0161ana inform\u0101cijas panelim atvieglos inform\u0101cijas pane\u013ca iestat\u012b\u0161anu, nodro\u0161in\u0101s t\u0101 nevainojamu darb\u012bbu un ietaup\u012bs daudz laika. P\u0101rliecinieties, vai katrai darbgr\u0101matas lapai, no kuras datus izmantosit inform\u0101cijas pane\u013ca izveidei, ir atsevi\u0161\u0137s nosaukums.<\/p>\n<h2 id=\"step-1-import-the-data-into-excel\">1.\u00a0darb\u012bba. Import\u0113jiet datus programm\u0101 Excel<\/h2>\n<p>Varat nekav\u0113joties s\u0101kt izveidot inform\u0101cijas paneli, ja j\u016bsu dati jau ir pieejami programm\u0101 Excel. Ja t\u0101 nav, vispirms tas b\u016bs j\u0101import\u0113 programm\u0101. To var izdar\u012bt da\u017e\u0101dos veidos, piem\u0113ram, kop\u0113jot un iel\u012bm\u0113jot to Excel darbgr\u0101mat\u0101, izmantojot API, piem\u0113ram, Open Database Connectivity (ODBC) vai Supermetrics, vai pievienojumprogrammu, piem\u0113ram, Microsoft Power Query. Tom\u0113r vienk\u0101r\u0161\u0101kais veids ir vienk\u0101r\u0161i izmantot opciju \u201cIeg\u016bt datus\u201d.<\/p>\n<ul>\n<li>Atveriet tuk\u0161u Excel lapu un noklik\u0161\u0137iniet uz cilnes &#8220;Dati&#8221; aug\u0161pus\u0113.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"484\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-14-27-40-1.webp\" title=\"\" width=\"861\"\/><\/figure>\n<ul>\n<li>Kad esat atv\u0113ris cilni Dati, noklik\u0161\u0137iniet uz opcijas \u201cIeg\u016bt datus\u201d kreisaj\u0101 pus\u0113 un p\u0113c tam dodieties uz \u201cNo faila\u201d un p\u0113c tam noklik\u0161\u0137iniet uz \u201cNo Excel darbgr\u0101matas\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"528\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-14-27-400-1.webp\" title=\"\" width=\"939\"\/><\/figure>\n<ul>\n<li>P\u0113c tam p\u0101rejiet uz vietu, kur atrodas dati, kurus v\u0113laties import\u0113t, un atlasiet tos. Pagaidiet, l\u012bdz programma Excel import\u0113 datus un sagatavo tos lieto\u0161anai.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"465\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-15-02-03-1.webp\" title=\"\" width=\"827\"\/><\/figure>\n<h2 id=\"step-2-set-up-your-workbook\">2.\u00a0darb\u012bba: iestatiet darbgr\u0101matu<\/h2>\n<ul>\n<li>Atveriet jaunu Excel darbgr\u0101matu un izveidojiet vismaz divas cilnes vai darblapas. Piem\u0113ram, izveidojiet tr\u012bs cilnes un pie\u0161\u0137iriet t\u0101m nosaukumus \u201cNeapstr\u0101d\u0101ti dati\u201d, \u201cDiagrammas dati\u201d un \u201cInform\u0101cijas panelis\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"448\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-08-30-15-10-16-1.webp\" title=\"\" width=\"796\"\/><\/figure>\n<ul>\n<li>Neapstr\u0101d\u0101tajiem datiem darbgr\u0101mat\u0101 ir j\u0101b\u016bt Excel tabulas veid\u0101 ar da\u017e\u0101diem datu punktiem da\u017e\u0101d\u0101s \u0161\u016bn\u0101s. \u0160o procesu bie\u017ei sauc par \u201cdatu t\u012br\u012b\u0161anu\u201d, un j\u016bs varat izmantot \u0161o iesp\u0113ju, lai atrastu un no\u0146emtu iesp\u0113jam\u0101s k\u013c\u016bdas.<\/li>\n<li>Kad dati ir izt\u012br\u012bti, ir pien\u0101cis laiks tos analiz\u0113t. Izp\u0113tiet datus un izlemiet, ko v\u0113laties iek\u013caut Excel inform\u0101cijas panel\u012b.<\/li>\n<li>Lai darblapai \u201cDiagrammas dati\u201d pievienotu nepiecie\u0161amos datu punktus, kop\u0113jiet tos un iel\u012bm\u0113jiet darblap\u0101.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"466\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-12-1.webp\" title=\"\" width=\"828\"\/><\/figure>\n<h2 id=\"step-3-create-your-dashboard\">3.\u00a0darb\u012bba. Izveidojiet inform\u0101cijas paneli<\/h2>\n<p>Kad esat sagatavojis datus sav\u0101 Excel darblap\u0101 un izl\u0113mis par inform\u0101cijas pane\u013ca m\u0113r\u0137i, ir pien\u0101cis laiks to izveidot. Tagad jums jau bija j\u0101nosaka, k\u0101 v\u0113laties vizu\u0101li par\u0101d\u012bt datus\u00a0\u2014 sektoru diagramm\u0101, rakurdiagramm\u0101, joslu diagramm\u0101 utt. S\u0101ksim ar kopu kolonnu diagrammu.<\/p>\n<ul>\n<li>Noklik\u0161\u0137iniet uz \u201cinform\u0101cijas pane\u013ca\u201d darblapas Excel darbgr\u0101matas apak\u0161\u0101, lai p\u0101rsl\u0113gtos uz to.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-13-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Kad esat atv\u0113rts darblap\u0101 \u201cInform\u0101cijas panelis\u201d, aug\u0161pus\u0113 noklik\u0161\u0137iniet uz izv\u0113lnes \u201cIevietot\u201d un p\u0113c tam noklik\u0161\u0137iniet uz nolai\u017eam\u0101s pogas blakus ikonai \u201ckolonnas\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-46-52-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Par\u0101d\u012btaj\u0101 nolai\u017eamaj\u0101 izv\u0113ln\u0113 noklik\u0161\u0137iniet uz ikonas \u201ckopu kolonna\u201d. Ja izmantojat vec\u0101ku Excel versiju, ikonas var par\u0101d\u012bties at\u0161\u0137ir\u012bgi.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"479\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-46-52-2-1.webp\" title=\"\" width=\"852\"\/><\/figure>\n<ul>\n<li>Tagad inform\u0101cijas pane\u013ca darblap\u0101 j\u0101par\u0101d\u0101s tuk\u0161am lodzi\u0146am. Ar peles labo pogu noklik\u0161\u0137iniet uz t\u0101 un p\u0113c tam noklik\u0161\u0137iniet uz &#8220;Atlas\u012bt datus&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"494\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-51-01-1.webp\" title=\"\" width=\"878\"\/><\/figure>\n<ul>\n<li>P\u0113c tam noklik\u0161\u0137iniet uz cilnes &#8220;Diagrammas dati&#8221; apak\u0161\u0101 un atlasiet datus, kurus v\u0113laties iek\u013caut inform\u0101cijas panel\u012b. Neatlasiet galvenes, atlasot datus, kas j\u0101iek\u013cauj kolonnu diagramm\u0101.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"491\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-10-56-25-1.webp\" title=\"\" width=\"872\"\/><\/figure>\n<ul>\n<li>Nospiediet tausti\u0146u Enter, un j\u016bsu priek\u0161\u0101 par\u0101d\u012bsies kopu kolonnu diagrammas inform\u0101cijas panelis.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"457\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-01-11-1.webp\" title=\"\" width=\"812\"\/><\/figure>\n<ul>\n<li>Diagrammu var redi\u0123\u0113t, v\u0113lreiz ar peles labo pogu noklik\u0161\u0137inot uz t\u0101s un noklik\u0161\u0137inot uz opcijas \u201cAtlas\u012bt datus\u201d, k\u0101 iepriek\u0161.<\/li>\n<li>Tiks atv\u0113rts dialoglodzi\u0146\u0161 \u201cAtlas\u012bt datu avotu\u201d. Noklik\u0161\u0137iniet uz pogas Redi\u0123\u0113t zem &#8220;Horizont\u0101l\u0101s (kategorijas) ass eti\u0137etes&#8221;, pirms atlas\u0101t datus, ko v\u0113laties par\u0101d\u012bt.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"439\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-09-33-1.webp\" title=\"\" width=\"781\"\/><\/figure>\n<ul>\n<li>Varat ar\u012b pie\u0161\u0137irt diagrammai nosaukumu. Vienk\u0101r\u0161i veiciet dubultklik\u0161\u0137i diagrammas aug\u0161da\u013c\u0101, kur ir rakst\u012bts &#8220;diagrammas nosaukums&#8221;, un ievadiet nosaukumu, kuru v\u0113laties izmantot.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"498\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/2024-09-03-11-12-41-1.webp\" title=\"\" width=\"885\"\/><\/figure>\n<h3 id=\"things-to-know\">Lietas, kas j\u0101zina<\/h3>\n<ul>\n<li>Atkar\u012bb\u0101 no t\u0101, kuru Microsoft Office versiju izmantojat, da\u017e\u0101d\u0101s izv\u0113ln\u0113s un ciln\u0113s var b\u016bt da\u017e\u0101das opcijas, piem\u0113ram, t\u0101s, kas kontrol\u0113 diagrammas dizainu.<\/li>\n<li>Lai inform\u0101cijas panelis b\u016btu visefekt\u012bv\u0101kais, noteikti izmantojiet konsekventas kr\u0101su sh\u0113mas, fontu stilus un format\u0113jumu.<\/li>\n<li>Ja v\u0113laties, lai inform\u0101cijas panelis autom\u0101tiski atspogu\u013cotu izmai\u0146as j\u016bsu datos, varat izv\u0113l\u0113ties dinamisko diagrammu, veidojot inform\u0101cijas paneli.<\/li>\n<li>Kad inform\u0101cijas panelis ir izveidots, pievienojiet eti\u0137etes un anot\u0101cijas da\u017e\u0101diem elementiem, lai b\u016btu viegli nodot inform\u0101ciju skat\u012bt\u0101jiem.<\/li>\n<li>Varat ar\u012b pievienot elementus, piem\u0113ram, pogas, filtrus un nolai\u017eam\u0101s izv\u0113lnes, lai padar\u012btu inform\u0101cijas paneli interakt\u012bvu un piel\u0101gojamu.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Ja j\u016bsu Excel lap\u0101s ir daudz datu, varat izveidot interakt\u012bvu inform\u0101cijas paneli, kas \u013cauj \u0113rti p\u0101rvald\u012bt \u0161os datus. Inform\u0101cijas panel\u012b ir apkopota galven\u0101 inform\u0101cija, lai j\u016bs var\u0113tu \u0101tri un vien\u0101 mirkl\u012b ieg\u016bt nepiecie\u0161amo inform\u0101ciju. Pirmk\u0101rt, jums ir j\u0101izlemj, k\u0101du inform\u0101ciju v\u0113laties r\u0101d\u012bt inform\u0101cijas panel\u012b. P\u0101rskatiet savus datus un izlemiet, ko iek\u013caut inform\u0101cijas panel\u012b, k\u0101 ar\u012b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[62,130,286],"class_list":["post-3389","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/3389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=3389"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/3389\/revisions"}],"predecessor-version":[{"id":3390,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/3389\/revisions\/3390"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=3389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=3389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=3389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}