{"id":932,"date":"2017-05-08T09:46:20","date_gmt":"2017-05-08T07:46:20","guid":{"rendered":"https:\/\/joergnapp.de\/?p=932"},"modified":"2017-04-17T09:51:53","modified_gmt":"2017-04-17T07:51:53","slug":"excel-kategorien-diagramme","status":"publish","type":"post","link":"https:\/\/joergnapp.de\/blog\/excel-kategorien-diagramme\/","title":{"rendered":"Excel: Kategorien in Diagrammen"},"content":{"rendered":"<p>Excel kann in Diagrammen auch Kategorien darstellen. Nehmen wir folgende Tabelle an:<\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/01.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-933\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/01-300x120.png\" alt=\"\" width=\"300\" height=\"120\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/01-300x120.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/01.png 315w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Markiert man nun die gesamte Tabelle und erstellt ein Diagramm&#8230;<\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/02.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-934\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/02-300x121.png\" alt=\"\" width=\"300\" height=\"121\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/02-300x121.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/02.png 318w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/03.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-935\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/03-300x84.png\" alt=\"\" width=\"300\" height=\"84\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/03-300x84.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/03.png 416w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&#8230;so enth\u00e4lt dieses Diagram die Spalte &#8222;Gebiet&#8220; als \u00fcbergeordnete Kategorie:<\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/03a.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-936\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/03a-300x200.png\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/03a-300x200.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/03a.png 568w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Das Ganze funktioniert auch mit mehreren Ebenen. Aus<\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/04.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-937\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/04-300x136.png\" alt=\"\" width=\"300\" height=\"136\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/04-300x136.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/04.png 402w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>wird<\/p>\n<p><a href=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/05.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-938\" src=\"https:\/\/joergnapp.de\/wp-content\/uploads\/2017\/04\/05-300x200.png\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/05-300x200.png 300w, https:\/\/joergnapp.de\/blog\/wp-content\/uploads\/2017\/04\/05.png 568w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel kann in Diagrammen auch Kategorien darstellen. Nehmen wir folgende Tabelle an: Markiert man nun die gesamte Tabelle und erstellt ein Diagramm&#8230; &#8230;so enth\u00e4lt dieses Diagram die Spalte &#8222;Gebiet&#8220; als \u00fcbergeordnete Kategorie: Das Ganze funktioniert auch mit mehreren Ebenen. Aus wird<\/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":[10],"class_list":["post-932","post","type-post","status-publish","format-standard","hentry","category-allgemein","tag-excel"],"_links":{"self":[{"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/posts\/932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/comments?post=932"}],"version-history":[{"count":0,"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/posts\/932\/revisions"}],"wp:attachment":[{"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/media?parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/categories?post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/joergnapp.de\/blog\/wp-json\/wp\/v2\/tags?post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}