{"id":4852,"date":"2018-07-16T08:07:30","date_gmt":"2018-07-16T06:07:30","guid":{"rendered":"http:\/\/www.ramses.de\/?p=4852"},"modified":"2018-07-16T08:08:17","modified_gmt":"2018-07-16T06:08:17","slug":"faq-excel-name-als-feld-oder-matrix-2-2-2-2-2","status":"publish","type":"post","link":"https:\/\/www.ramses.de\/?p=4852","title":{"rendered":"FAQ Excel &#8211; Trendline im Diagramm"},"content":{"rendered":"<h2><strong>Trendlinie<\/strong><\/h2>\n<p>Excel wird gerne genommen, um statistische Daten darzustellen. Bei der Darstellung der Zahlen ist nat\u00fcrlich auch die zuk\u00fcnftige Entwicklung der Zahlen interessant. Gehen wir von folgenden Zahlen aus, die die Photovoltaik Leistungen in Deutschland darstellt.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4853\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND01.jpg\" alt=\"\" width=\"275\" height=\"367\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND01.jpg 275w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND01-225x300.jpg 225w\" sizes=\"auto, (max-width: 275px) 100vw, 275px\" \/><\/p>\n<p>Wir erzeugen daraus ein S\u00e4ulendiagramm, m\u00fcssen allerdings im Nachhinein die Jahreszahlen als Achsenbeschriftung definieren.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4854\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND02-300x194.jpg\" alt=\"\" width=\"300\" height=\"194\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND02-300x194.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND02-768x497.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND02-1024x662.jpg 1024w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND02.jpg 1698w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Im Anschlu\u00df w\u00e4hlen wir das Kontextmen\u00fc der S\u00e4ule aus und nehmen die Trendlinie<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4855\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND03.jpg\" alt=\"\" width=\"470\" height=\"350\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND03.jpg 470w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND03-300x223.jpg 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/p>\n<p>Wir bekommen eine lineare Trendlinie.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-4856\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND04-300x193.jpg\" alt=\"\" width=\"300\" height=\"193\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND04-300x193.jpg 300w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND04-768x495.jpg 768w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND04-1024x659.jpg 1024w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND04.jpg 1705w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>In den Eigenschaften k\u00f6nnen wir die Art des Trends festlegen<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4857\" src=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND05.jpg\" alt=\"\" width=\"440\" height=\"605\" srcset=\"https:\/\/www.ramses.de\/wp-content\/uploads\/TREND05.jpg 440w, https:\/\/www.ramses.de\/wp-content\/uploads\/TREND05-218x300.jpg 218w\" sizes=\"auto, (max-width: 440px) 100vw, 440px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Trendlinie Excel wird gerne genommen, um statistische Daten darzustellen. Bei der Darstellung der Zahlen ist nat\u00fcrlich auch die zuk\u00fcnftige Entwicklung der Zahlen interessant. Gehen wir &#8230; <a title=\"FAQ Excel &#8211; Trendline im Diagramm\" class=\"read-more\" href=\"https:\/\/www.ramses.de\/?p=4852\" aria-label=\"Mehr Informationen \u00fcber FAQ Excel &#8211; Trendline im Diagramm\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[60,61],"class_list":["post-4852","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel-2010","tag-vba"],"_links":{"self":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/4852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4852"}],"version-history":[{"count":2,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/4852\/revisions"}],"predecessor-version":[{"id":4859,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/4852\/revisions\/4859"}],"wp:attachment":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}