{"id":1527,"date":"2021-10-11T15:30:32","date_gmt":"2021-10-11T13:30:32","guid":{"rendered":"https:\/\/centrum-vzdelavani.cz\/?p=1527"},"modified":"2021-10-11T15:40:28","modified_gmt":"2021-10-11T13:40:28","slug":"tvorba-bcg-grafu-v-ms-excel","status":"publish","type":"post","link":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/","title":{"rendered":"Tvorba BCG graf\u016f v&nbsp;MS Excel"},"content":{"rendered":"\n<p>Americk\u00e1 spole\u010dnost Boston Consulting Group vyvinula v&nbsp;roce 1968 maticov\u00fd model strategie firemn\u00edho portfolia, kter\u00fd se v&nbsp;praxi skv\u011ble osv\u011bd\u010dil. Z&nbsp;po\u010d\u00e1te\u010dn\u00edch p\u00edsmen spole\u010dnosti vznikla zkratka v&nbsp;n\u00e1zvu. Nam\u00edsto <strong>BCG matice<\/strong> (<em>anglicky BCG matrix<\/em>) se j\u00ed n\u011bkdy tak\u00e9 \u0159\u00edk\u00e1 <strong>Bostonsk\u00e1 matice<\/strong>. Portfolio produkt\u016f se v&nbsp;n\u00ed rozd\u011bluje do \u010dty\u0159 kategori\u00ed a t\u00edm se rozhoduje, do kter\u00fdch z&nbsp;nich se vyplat\u00ed investovat.<\/p>\n\n\n\n<p>Na <strong>BCG matici<\/strong> se v&nbsp;sou\u010dasnosti n\u011bkte\u0159\u00ed praktici strategick\u00e9ho \u0159\u00edzen\u00ed d\u00edvaj\u00ed s&nbsp;lehkou ned\u016fv\u011brou. Pro stejn\u00fd \u00fa\u010del jsou dnes k&nbsp;dispozici i jin\u00e9 p\u0159esn\u011bj\u0161\u00ed modely. P\u0159esto je <strong>Bostonsk\u00e1 matice <\/strong>pro svou jednoduchost a&nbsp;prakti\u010dnost st\u00e1le velmi pou\u017e\u00edvan\u00e1.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Jak vypad\u00e1 BCG matice?<\/h2>\n\n\n\n<p>Bostonsk\u00e1 matice je graf se dv\u011bma osami a \u010dty\u0159mi kvadranty.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-us_600_315\"><a ref=\"magnificPopup\" href=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG.png\"><img decoding=\"async\" width=\"600\" height=\"274\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-600x274.png\" alt=\"BCG matice\" class=\"wp-image-1529\" srcset=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-600x274.png 600w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-300x137.png 300w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-1024x468.png 1024w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-1200x549.png 1200w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG.png 1467w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><figcaption>BCG matice<\/figcaption><\/figure><\/div>\n\n\n\n<p>Na vodorovn\u00e9 ose se zobrazuje <strong>relativn\u00ed tr\u017en\u00ed pod\u00edl<\/strong>, co\u017e je pom\u011br na\u0161ich tr\u017eeb v\u016f\u010di tr\u017eb\u00e1m hlavn\u00ed konkurence. Hodnoty na ose jsou klesaj\u00edc\u00ed od 10 do 0,1. Hranic\u00ed mezi velk\u00fdm a mal\u00fdm p\u0159\u00edr\u016fstkem tr\u017eeb je hodnota 1.<\/p>\n\n\n\n<p>Na svisl\u00e9 ose je zobrazen\u00e9 <strong>tempo r\u016fstu<\/strong>, kter\u00e9 v&nbsp;procentech ud\u00e1v\u00e1, jak rychle rostou tr\u017eby z&nbsp;dan\u00e9ho produktu. Jej\u00ed hodnoty jsou od 0&nbsp;% do 20&nbsp;%. Za mezn\u00edk mezi pomal\u00fdm a vysok\u00fdm tempem r\u016fstu se pova\u017euje 10&nbsp;%.<\/p>\n\n\n\n<p>Mezn\u00edky obou os rozd\u011bluj\u00ed produkty do \u010dty\u0159 kategori\u00ed.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Otazn\u00edky<\/strong><br>N\u00edzk\u00fd tr\u017en\u00ed pod\u00edl spole\u010dn\u011b s&nbsp;rychl\u00fdm tempem r\u016fstu znamen\u00e1 nestabiln\u00ed pozici. Podle pr\u016fzkumu trhu je t\u0159eba zvolit investov\u00e1n\u00ed nebo \u00fatlum.<\/li><li><strong>Hv\u011bzdy<\/strong><br>Jde o produkty s&nbsp;nejlep\u0161\u00edmi obchodn\u00edmi v\u00fdsledky i p\u0159edpoklady. V&nbsp;budoucnu by mohly b\u00fdt hlavn\u00edm zdrojem zisku, vyplat\u00ed se do nich investovat.<\/li><li><strong>Dojn\u00e9<\/strong> <strong>kr\u00e1vy<\/strong><br>Vytv\u00e1\u0159ej\u00ed velk\u00e9 mno\u017estv\u00ed finan\u010dn\u00edch prost\u0159edk\u016f, kter\u00e9 m\u016f\u017eeme investovat do ostatn\u00edch skupin.<\/li><li><strong>B\u00eddn\u00ed<\/strong> <strong>psi<\/strong><br>Nejsou perspektivn\u00ed. Je t\u0159eba rozhodnout, zda zastavit v\u00fdrobu t\u011bchto produkt\u016f nebo uskute\u010dnit inova\u010dn\u00ed z\u00e1sah \u010di rekonstrukce v\u00fdrobn\u00edch program\u016f<\/li><\/ul>\n\n\n\n<p>Nov\u00fd produkt se b\u011b\u017en\u011b ocit\u00e1 v&nbsp;kvadrantu otazn\u00edk\u016f. Pokud je \u00fasp\u011b\u0161n\u00fd, vy\u0161plh\u00e1 se mezi hv\u011bzdy. Zde z\u016fst\u00e1v\u00e1, dokud jej firma dostate\u010dn\u011b financuje, jinak se p\u0159esouv\u00e1 do kvadrantu dojn\u00fdch krav. Tady vydr\u017e\u00ed, dokud u n\u011bj prob\u00edhaj\u00ed dostate\u010dn\u00e9 inovace. V&nbsp;posledn\u00ed f\u00e1zi se produkt propad\u00e1 do kvadrantu b\u00eddn\u00fdch ps\u016f, a\u017e je sta\u017een z&nbsp;trhu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tvorba BCG grafu v&nbsp;MS Excel<\/h2>\n\n\n\n<p>V&nbsp;Excelu se BCG matice tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu. Stru\u010dn\u00fd postup je n\u00e1sleduj\u00edc\u00ed.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Ozna\u010dte pr\u00e1zdnou bu\u0148ku a vlo\u017ete bublinov\u00fd graf.<\/li><li>Zvolte <strong>Vybrat data<\/strong> a pro hodnoty 1.&nbsp;\u0159ady grafu pou\u017eijte hodnoty prv\u00e9ho produktu z&nbsp;tabulky.<\/li><li>Podobn\u011b jako v&nbsp;p\u0159edchoz\u00edm kroku p\u0159idejte hodnoty pro dal\u0161\u00ed \u0159ady grafu.<\/li><li>Nastavte obr\u00e1cen\u00e9 po\u0159ad\u00ed hodnot vodorovn\u00e9 osy.<\/li><li>Na vodorovn\u00e9 ose nastavte pr\u016fse\u010d\u00edk se svislou v&nbsp;hodnot\u011b <strong>1<\/strong>.<\/li><li>Na svisl\u00e9 ose nastavte pr\u016fse\u010d\u00edk s&nbsp;vodorovnou v&nbsp;hodnot\u011b <strong>10&nbsp;%<\/strong>.<\/li><li>Skryjte popisky na obou os\u00e1ch.<\/li><li>Pro v\u0161echny bubliny nastavte zobrazov\u00e1n\u00ed popisk\u016f s&nbsp;n\u00e1zvy produkt\u016f.<\/li><li>P\u0159idejte do ka\u017ed\u00e9 \u010d\u00e1sti grafu odpov\u00eddaj\u00edc\u00ed textov\u00fd popisek.<\/li><\/ol>\n\n\n\n<p>Jak takov\u00fd BCG bublinov\u00fd graf v&nbsp;Excelu m\u016f\u017ee vypadat, ukazuje situace na obr\u00e1zku.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-us_600_315\"><a ref=\"magnificPopup\" href=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel.png\"><img decoding=\"async\" width=\"600\" height=\"239\" src=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel-600x239.png\" alt=\"Tabulka s daty a BCG graf v Excelu\" class=\"wp-image-1530\" srcset=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel-600x239.png 600w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel-300x119.png 300w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel-1024x407.png 1024w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel-1200x477.png 1200w, https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/BCG-Excel.png 1562w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><figcaption>Tabulka s&nbsp;daty a BCG graf v&nbsp;Excelu<\/figcaption><\/figure><\/div>\n\n\n\n<p>Mo\u017en\u00e1, \u017ee v\u00fd\u0161e uveden\u00fd postup je pro v\u00e1s p\u0159\u00edli\u0161 stru\u010dn\u00fd. Ke zd\u00e1rn\u00e9mu dokon\u010den\u00ed pot\u0159ebuje p\u0159esn\u011bj\u0161\u00ed veden\u00ed, p\u0159\u00edpadn\u011b, v\u00edce praktick\u00fdch cvi\u010den\u00ed. Mo\u017en\u00e1, \u017ee byste se cht\u011bli nau\u010dit i rychlej\u0161\u00ed postup, kdy sice vznikne graf jen s&nbsp;jednou \u0159adou, ale vede ke stejn\u011b vypadaj\u00edc\u00edmu v\u00fdsledku. V&nbsp;tom p\u0159\u00edpad\u011b se p\u0159ihlaste do n\u011bkter\u00e9ho z&nbsp;na\u0161ich kurz\u016f pro pokro\u010dilej\u0161\u00ed pr\u00e1ci v&nbsp;Excelu, nap\u0159. <a href=\"https:\/\/centrum-vzdelavani.cz\/skoleni-a-kurzy\/firemni-kurzy\/kancelarsky-balik-ms-office-libreoffice\/#ms-excel-pokrocili\" target=\"_blank\" rel=\"noreferrer noopener\">MS Excel \u2013 pokro\u010dil\u00ed<\/a> nebo <a href=\"https:\/\/centrum-vzdelavani.cz\/skoleni-a-kurzy\/dalsi-vzdelavani-pedagogickych-pracovniku\/akreditovane-kurzy-sablony-ict\/#ict-ms-excel-iii-vizualizace-dat-8-hodin-\" target=\"_blank\" rel=\"noreferrer noopener\">MS Excel III. \u2013 vizualizace dat<\/a> nj., ve kter\u00fdch je tento typ grafu mo\u017en\u00e9 probrat.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed v&nbsp;MS Excel.<\/p>\n","protected":false},"author":6,"featured_media":1545,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10,4],"tags":[234,11,84,166,21],"class_list":["post-1527","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dvpp","category-firemni-skoleni","tag-bcg-matice","tag-dvpp","tag-firemni-skoleni","tag-firemni-vzdelavani","tag-ms-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ<\/title>\n<meta name=\"description\" content=\"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"og:description\" content=\"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-11T13:30:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-11T13:40:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Zden\u011bk Kom\u00ednek\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napsal(a)\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zden\u011bk Kom\u00ednek\" \/>\n\t<meta name=\"twitter:label2\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\"},\"author\":{\"name\":\"Zden\u011bk Kom\u00ednek\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/abe2156ed3e680449877a31f8a75ed0f\"},\"headline\":\"Tvorba BCG graf\u016f v&nbsp;MS Excel\",\"datePublished\":\"2021-10-11T13:30:32+00:00\",\"dateModified\":\"2021-10-11T13:40:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\"},\"wordCount\":701,\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg\",\"keywords\":[\"BCG matice\",\"DVPP\",\"firemn\u00ed \u0161kolen\u00ed\",\"Firemn\u00ed vzd\u011bl\u00e1v\u00e1n\u00ed\",\"MS Excel\"],\"articleSection\":[\"DVPP\",\"Firemn\u00ed \u0161kolen\u00ed\"],\"inLanguage\":\"cs\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\",\"name\":\"Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"isPartOf\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg\",\"datePublished\":\"2021-10-11T13:30:32+00:00\",\"dateModified\":\"2021-10-11T13:40:28+00:00\",\"description\":\"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Tvorba BCG graf\u016f v MS Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dom\u016f\",\"item\":\"https:\/\/centrum-vzdelavani.cz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tvorba BCG graf\u016f v&nbsp;MS Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#website\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"name\":\"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ\",\"description\":\"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky\",\"publisher\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#organization\",\"name\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"contentUrl\":\"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg\",\"width\":\"1024\",\"height\":\"1024\",\"caption\":\"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.\"},\"image\":{\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/abe2156ed3e680449877a31f8a75ed0f\",\"name\":\"Zden\u011bk Kom\u00ednek\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g\",\"caption\":\"Zden\u011bk Kom\u00ednek\"},\"description\":\"Lektor IT, ECDL Expert a tester a Microsoft Office Specialist\",\"sameAs\":[\"https:\/\/centrum-vzdelavani.cz\"],\"url\":\"https:\/\/centrum-vzdelavani.cz\/author\/zkominek\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/","og_locale":"cs_CZ","og_type":"article","og_title":"Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","og_description":"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.","og_url":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/","og_site_name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","article_published_time":"2021-10-11T13:30:32+00:00","article_modified_time":"2021-10-11T13:40:28+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","type":"image\/jpeg"}],"author":"Zden\u011bk Kom\u00ednek","twitter_card":"summary_large_image","twitter_misc":{"Napsal(a)":"Zden\u011bk Kom\u00ednek","Odhadovan\u00e1 doba \u010dten\u00ed":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#article","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/"},"author":{"name":"Zden\u011bk Kom\u00ednek","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/abe2156ed3e680449877a31f8a75ed0f"},"headline":"Tvorba BCG graf\u016f v&nbsp;MS Excel","datePublished":"2021-10-11T13:30:32+00:00","dateModified":"2021-10-11T13:40:28+00:00","mainEntityOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/"},"wordCount":701,"publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","keywords":["BCG matice","DVPP","firemn\u00ed \u0161kolen\u00ed","Firemn\u00ed vzd\u011bl\u00e1v\u00e1n\u00ed","MS Excel"],"articleSection":["DVPP","Firemn\u00ed \u0161kolen\u00ed"],"inLanguage":"cs"},{"@type":"WebPage","@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/","url":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/","name":"Tvorba BCG graf\u016f v MS Excel &#187; CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","isPartOf":{"@id":"https:\/\/centrum-vzdelavani.cz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage"},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","datePublished":"2021-10-11T13:30:32+00:00","dateModified":"2021-10-11T13:40:28+00:00","description":"\u010cl\u00e1nek o tom, co je to BCG matice, jak se pou\u017e\u00edv\u00e1 pro firemn\u00ed strategii portfolia v\u00fdrobk\u016f a jak se tvo\u0159\u00ed pomoc\u00ed bublinov\u00e9ho grafu v MS Excel.","breadcrumb":{"@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#primaryimage","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","width":1200,"height":630,"caption":"Tvorba BCG graf\u016f v MS Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/centrum-vzdelavani.cz\/tvorba-bcg-grafu-v-ms-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Dom\u016f","item":"https:\/\/centrum-vzdelavani.cz\/"},{"@type":"ListItem","position":2,"name":"Tvorba BCG graf\u016f v&nbsp;MS Excel"}]},{"@type":"WebSite","@id":"https:\/\/centrum-vzdelavani.cz\/#website","url":"https:\/\/centrum-vzdelavani.cz\/","name":"CENTRUM-VZD\u011aL\u00c1V\u00c1N\u00cd.CZ","description":"Va\u0161e m\u00edsto pro kurzy, \u0161kolen\u00ed a zkou\u0161ky","publisher":{"@id":"https:\/\/centrum-vzdelavani.cz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/centrum-vzdelavani.cz\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"},{"@type":"Organization","@id":"https:\/\/centrum-vzdelavani.cz\/#organization","name":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o.","url":"https:\/\/centrum-vzdelavani.cz\/","logo":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/","url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","contentUrl":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/08\/Centrum-Vzdelavani-logo-cerne.svg","width":"1024","height":"1024","caption":"Po\u010d\u00edta\u010dov\u00e1 slu\u017eba s.r.o."},"image":{"@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/abe2156ed3e680449877a31f8a75ed0f","name":"Zden\u011bk Kom\u00ednek","image":{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/centrum-vzdelavani.cz\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28ee5a8fc57665deeb1aaf3efef28433?s=96&d=mm&r=g","caption":"Zden\u011bk Kom\u00ednek"},"description":"Lektor IT, ECDL Expert a tester a Microsoft Office Specialist","sameAs":["https:\/\/centrum-vzdelavani.cz"],"url":"https:\/\/centrum-vzdelavani.cz\/author\/zkominek\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/centrum-vzdelavani.cz\/wp-content\/uploads\/2021\/10\/CV-Tvorba-BCG-grafu-v-MS-Excel-bostonska-matice.jpg","_links":{"self":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/1527"}],"collection":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/comments?post=1527"}],"version-history":[{"count":0,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/posts\/1527\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media\/1545"}],"wp:attachment":[{"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/media?parent=1527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/categories?post=1527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centrum-vzdelavani.cz\/wp-json\/wp\/v2\/tags?post=1527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}