{"id":3389,"date":"2024-09-03T13:08:42","date_gmt":"2024-09-03T13:08:42","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=3389"},"modified":"2024-09-03T13:08:42","modified_gmt":"2024-09-03T13:08:42","slug":"how-to-create-a-dashboard-in-excel-cs","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/how-to-create-a-dashboard-in-excel-cs\/","title":{"rendered":"Jak vytvo\u0159it \u0159\u00eddic\u00ed panel v Excelu"},"content":{"rendered":"<p>Pokud va\u0161e excelov\u00e9 listy obsahuj\u00ed mnoho dat, m\u016f\u017eete vytvo\u0159it interaktivn\u00ed \u0159\u00eddic\u00ed panel, kter\u00fd v\u00e1m umo\u017en\u00ed tato data snadno spravovat. \u0158\u00eddic\u00ed panel shrnuje kl\u00ed\u010dov\u00e9 detaily, tak\u017ee pot\u0159ebn\u00e9 informace z\u00edsk\u00e1te rychle na prvn\u00ed pohled. Nejprve se mus\u00edte rozhodnout, jak\u00e9 informace chcete na \u0159\u00eddic\u00edm panelu zobrazovat. Projd\u011bte si sv\u00e1 data a rozhodn\u011bte se, co zahrnout do \u0159\u00eddic\u00edho panelu a jak tyto informace zobrazit. M\u016f\u017eete si vybrat, zda jej zobraz\u00edte jako spojnicov\u00e9 grafy, kol\u00e1\u010dov\u00e9 grafy, bodov\u00e9 grafy nebo n\u011bco jin\u00e9ho.<\/p>\n<p>Jakmile se rozhodnete, jak\u00e1 data zahrnout a jak je zobrazit na \u0159\u00eddic\u00edm panelu, je \u010das je p\u0159ipravit. P\u0159\u00edprava dat pro \u0159\u00eddic\u00ed panel usnadn\u00ed nastaven\u00ed \u0159\u00eddic\u00edho panelu, zajist\u00ed jeho hladk\u00e9 fungov\u00e1n\u00ed a u\u0161et\u0159\u00ed spoustu \u010dasu. Ujist\u011bte se, \u017ee ka\u017ed\u00fd list v se\u0161itu, ze kter\u00e9ho pou\u017eijete data k vytvo\u0159en\u00ed \u0159\u00eddic\u00edho panelu, m\u00e1 samostatn\u00fd n\u00e1zev.<\/p>\n<h2 id=\"step-1-import-the-data-into-excel\">Krok 1: Importujte data do Excelu<\/h2>\n<p>Pokud jsou va\u0161e data ji\u017e v Excelu p\u0159\u00edtomna, m\u016f\u017eete za\u010d\u00edt vytv\u00e1\u0159et \u0159\u00eddic\u00ed panel ihned. Pokud tomu tak nen\u00ed, mus\u00edte jej nejprve importovat do programu. M\u016f\u017eete to ud\u011blat r\u016fzn\u00fdmi zp\u016fsoby, jako je zkop\u00edrov\u00e1n\u00ed a vlo\u017een\u00ed do se\u0161itu aplikace Excel, pomoc\u00ed rozhran\u00ed API, jako je Open Database Connectivity (ODBC) nebo Supermetrics, nebo dopl\u0148ku, jako je Microsoft Power Query. Nejjednodu\u0161\u0161\u00ed zp\u016fsob je v\u0161ak jednodu\u0161e pou\u017e\u00edt mo\u017enost \u201eZ\u00edskat data\u201c.<\/p>\n<ul>\n<li>Otev\u0159ete pr\u00e1zdn\u00fd list aplikace Excel a klikn\u011bte na kartu &#8216;Data&#8217; naho\u0159e.<\/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>Jakmile jste na kart\u011b Data, klikn\u011bte na mo\u017enost \u201eZ\u00edskat data\u201c vlevo a pot\u00e9 p\u0159ejd\u011bte na \u201eZe souboru\u201c a pot\u00e9 klikn\u011bte na \u201eZ se\u0161itu aplikace Excel\u201c.<\/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>Pot\u00e9 p\u0159ejd\u011bte na m\u00edsto, kde se nach\u00e1zej\u00ed data, kter\u00e1 chcete importovat, a vyberte je. Po\u010dkejte, a\u017e Excel importuje data a p\u0159iprav\u00ed je k pou\u017eit\u00ed.<\/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\">Krok 2: Nastavte si se\u0161it<\/h2>\n<ul>\n<li>Otev\u0159ete nov\u00fd se\u0161it aplikace Excel a vytvo\u0159te alespo\u0148 dv\u011b karty nebo listy. Vytvo\u0159te nap\u0159\u00edklad t\u0159i karty a pojmenujte je \u201eRaw Data\u201c, \u201eData grafu\u201c a \u201eDashboard\u201c.<\/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>Nezpracovan\u00e1 data ve va\u0161em se\u0161itu by m\u011bla b\u00fdt ve form\u011b tabulky aplikace Excel s r\u016fzn\u00fdmi datov\u00fdmi body v r\u016fzn\u00fdch bu\u0148k\u00e1ch. Tento proces je \u010dasto zn\u00e1m\u00fd jako \u201e\u010di\u0161t\u011bn\u00ed va\u0161ich dat\u201c a m\u016f\u017eete tuto p\u0159\u00edle\u017eitost vyu\u017e\u00edt k nalezen\u00ed a odstran\u011bn\u00ed p\u0159\u00edpadn\u00fdch chyb.<\/li>\n<li>Jakmile sv\u00e1 data vy\u010dist\u00edte, je \u010das je analyzovat. Prostudujte si data a rozhodn\u011bte se, co chcete zahrnout do \u0159\u00eddic\u00edho panelu aplikace Excel.<\/li>\n<li>Chcete-li p\u0159idat po\u017eadovan\u00e9 datov\u00e9 body do listu \u201eData grafu\u201c, zkop\u00edrujte je a vlo\u017ete do listu.<\/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\">Krok 3: Vytvo\u0159te si \u0159\u00eddic\u00ed panel<\/h2>\n<p>Jakmile p\u0159iprav\u00edte data v excelov\u00e9m listu a rozhodnete se pro \u00fa\u010del \u0159\u00eddic\u00edho panelu, je \u010das jej vytvo\u0159it. Nyn\u00ed byste ji\u017e m\u011bli m\u00edt ur\u010deno, jak chcete data zobrazit vizu\u00e1ln\u011b, zda jako v\u00fdse\u010dov\u00fd graf, kontingen\u010dn\u00ed graf, sloupcov\u00fd graf atd. Za\u010dn\u011bme seskupen\u00fdm sloupcov\u00fdm grafem.<\/p>\n<ul>\n<li>Kliknut\u00edm na pracovn\u00ed list \u201eDashboard\u201c v doln\u00ed \u010d\u00e1sti se\u0161itu aplikace Excel na n\u011bj p\u0159epnete.<\/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>Jakmile jste na pracovn\u00edm listu &#8216;dashboard&#8217;, klikn\u011bte na nab\u00eddku &#8216;Vlo\u017eit&#8217; v horn\u00ed \u010d\u00e1sti a pot\u00e9 klikn\u011bte na rozbalovac\u00ed tla\u010d\u00edtko vedle ikony &#8216;sloupce&#8217;.<\/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>V rozbalovac\u00ed nab\u00eddce, kter\u00e1 se zobraz\u00ed, klikn\u011bte na ikonu &#8216;shlukovan\u00fd sloupec&#8217;. Pokud pou\u017e\u00edv\u00e1te star\u0161\u00ed verzi Excelu, mohou se ikony zobrazovat jinak.<\/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>V listu \u0159\u00eddic\u00edho panelu by se nyn\u00ed m\u011blo objevit pr\u00e1zdn\u00e9 pole. Klikn\u011bte na n\u011bj prav\u00fdm tla\u010d\u00edtkem my\u0161i a pot\u00e9 klikn\u011bte na \u201eVybrat data\u201c.<\/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>D\u00e1le klikn\u011bte na z\u00e1lo\u017eku &#8216;Data grafu&#8217; v doln\u00ed \u010d\u00e1sti a vyberte data, kter\u00e1 chcete zahrnout do \u0159\u00eddic\u00edho panelu. P\u0159i v\u00fdb\u011bru dat, kter\u00e1 maj\u00ed b\u00fdt zahrnuta do sloupcov\u00e9ho grafu, nevyb\u00edrejte z\u00e1hlav\u00ed.<\/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>Stiskn\u011bte Enter a p\u0159ed v\u00e1mi by se m\u011bl objevit \u0159\u00eddic\u00ed panel seskupen\u00e9ho sloupcov\u00e9ho grafu.<\/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>Graf m\u016f\u017eete upravit tak, \u017ee na n\u011bj znovu kliknete prav\u00fdm tla\u010d\u00edtkem my\u0161i a kliknete na mo\u017enost \u201evybrat data\u201c jako d\u0159\u00edve.<\/li>\n<li>Zobraz\u00ed se dialogov\u00e9 okno \u201eVybrat zdroj dat\u201c. P\u0159ed v\u00fdb\u011brem dat, kter\u00e1 chcete zobrazit, klikn\u011bte na tla\u010d\u00edtko Upravit v \u010d\u00e1sti \u201e\u0160t\u00edtky os vodorovn\u00e9 (kategorie)\u201c.<\/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>Sv\u00e9mu grafu m\u016f\u017eete tak\u00e9 d\u00e1t n\u00e1zev. Jednodu\u0161e dvakr\u00e1t klikn\u011bte na horn\u00ed \u010d\u00e1st grafu, kde je naps\u00e1no \u201en\u00e1zev grafu\u201c, a zadejte n\u00e1zev, kter\u00fd chcete pou\u017e\u00edt.<\/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\">V\u011bci, kter\u00e9 byste m\u011bli v\u011bd\u011bt<\/h3>\n<ul>\n<li>V z\u00e1vislosti na verzi Microsoft Office, kterou pou\u017e\u00edv\u00e1te, mohou b\u00fdt v r\u016fzn\u00fdch nab\u00eddk\u00e1ch a kart\u00e1ch p\u0159\u00edtomny r\u016fzn\u00e9 mo\u017enosti, jako jsou ty, kter\u00e9 \u0159\u00edd\u00ed n\u00e1vrh grafu.<\/li>\n<li>Aby byl v\u00e1\u0161 \u0159\u00eddic\u00ed panel co nej\u00fa\u010dinn\u011bj\u0161\u00ed, ujist\u011bte se, \u017ee pou\u017e\u00edv\u00e1te konzistentn\u00ed barevn\u00e1 sch\u00e9mata, styly p\u00edsem a form\u00e1tov\u00e1n\u00ed.<\/li>\n<li>Pokud chcete, aby \u0159\u00eddic\u00ed panel automaticky odr\u00e1\u017eel zm\u011bny ve va\u0161ich datech, m\u016f\u017eete p\u0159i vytv\u00e1\u0159en\u00ed \u0159\u00eddic\u00edho panelu zvolit dynamick\u00fd graf.<\/li>\n<li>Jakmile je \u0159\u00eddic\u00ed panel vytvo\u0159en, p\u0159idejte \u0161t\u00edtky a pozn\u00e1mky k r\u016fzn\u00fdm prvk\u016fm, aby bylo snadn\u00e9 p\u0159edat informace div\u00e1k\u016fm.<\/li>\n<li>M\u016f\u017eete tak\u00e9 p\u0159idat prvky, jako jsou tla\u010d\u00edtka, filtry a rozev\u00edrac\u00ed nab\u00eddky, aby byl \u0159\u00eddic\u00ed panel interaktivn\u00ed a p\u0159izp\u016fsobiteln\u00fd.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Pokud va\u0161e excelov\u00e9 listy obsahuj\u00ed mnoho dat, m\u016f\u017eete vytvo\u0159it interaktivn\u00ed \u0159\u00eddic\u00ed panel, kter\u00fd v\u00e1m umo\u017en\u00ed tato data snadno spravovat. \u0158\u00eddic\u00ed panel shrnuje kl\u00ed\u010dov\u00e9 detaily, tak\u017ee pot\u0159ebn\u00e9 informace z\u00edsk\u00e1te rychle na prvn\u00ed pohled. Nejprve se mus\u00edte rozhodnout, jak\u00e9 informace chcete na \u0159\u00eddic\u00edm panelu zobrazovat. Projd\u011bte si sv\u00e1 data a rozhodn\u011bte se, co zahrnout do \u0159\u00eddic\u00edho panelu [&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":[57,126,283],"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\/cs\/wp-json\/wp\/v2\/posts\/3389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=3389"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/3389\/revisions"}],"predecessor-version":[{"id":3390,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/3389\/revisions\/3390"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=3389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=3389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=3389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}