{"id":4759,"date":"2024-10-17T09:08:58","date_gmt":"2024-10-17T09:08:58","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=4759"},"modified":"2024-10-17T09:08:58","modified_gmt":"2024-10-17T09:08:58","slug":"a-comprehensive-guide-on-using-the-trend-function-in-excel","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/a-comprehensive-guide-on-using-the-trend-function-in-excel\/","title":{"rendered":"Komplexn\u00ed pr\u016fvodce pou\u017e\u00edv\u00e1n\u00edm funkce TREND v Excelu"},"content":{"rendered":"<p>Funkce TREND v Excelu je v\u00fdkonn\u00fd n\u00e1stroj, kter\u00fd umo\u017e\u0148uje u\u017eivatel\u016fm vypo\u010d\u00edtat nejvhodn\u011bj\u0161\u00ed \u010d\u00e1ru pro data prezentovan\u00e1 v grafu pomoc\u00ed statistick\u00e9 metody nejmen\u0161\u00edch \u010dtverc\u016f. Z\u00e1kladn\u00ed rovnice pou\u017eit\u00e1 v t\u00e9to funkci je <code>y = mx + b<\/code>, kde <strong>y<\/strong> p\u0159edstavuje z\u00e1visle prom\u011bnnou, <strong>m<\/strong> je sklon p\u0159\u00edmky, <strong>x<\/strong> ozna\u010duje nez\u00e1vislou prom\u011bnnou a <strong>b<\/strong> ozna\u010duje bod, ve kter\u00e9m spojnice trendu prot\u00edn\u00e1 osu y.<\/p>\n<h2 id=\"using-the-trend-function\">Vyu\u017eit\u00ed funkce TREND<\/h2>\n<p>Funkce TREND m\u016f\u017ee b\u00fdt neoceniteln\u00e1 v r\u016fzn\u00fdch sc\u00e9n\u00e1\u0159\u00edch, nap\u0159\u00edklad p\u0159i anal\u00fdze p\u0159\u00edjm\u016f v ur\u010dit\u00e9m \u010dasov\u00e9m r\u00e1mci za \u00fa\u010delem identifikace jejich trendu.<\/p>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"538\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-303-1.webp\" title=\"\" width=\"957\"\/><\/figure>\n<ul>\n<li>Ve v\u00fd\u0161e uveden\u00e9m p\u0159\u00edkladu zadejte do bu\u0148ky C2 n\u00e1sleduj\u00edc\u00ed vzorec: <code>=TREND(B2:B14,A2:A14)<\/code>. V tomto p\u0159\u00edpad\u011b &#8216;B2:B14&#8217; p\u0159edstavuje zn\u00e1m\u00e9 hodnoty y a &#8216;A2:A14&#8217; znamen\u00e1 zn\u00e1m\u00e9 hodnoty x.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"430\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-304-1.webp\" title=\"\" width=\"764\"\/><\/figure>\n<ul>\n<li>Stiskn\u011bte Enter a trend se v tabulce zobraz\u00ed jako pole.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"521\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-305-1.webp\" title=\"\" width=\"927\"\/><\/figure>\n<ul>\n<li>Jakmile je trend stanoven, m\u016f\u017eete p\u0159edpov\u00eddat data pro budouc\u00ed obdob\u00ed zad\u00e1n\u00edm <code>=TREND(B2:B14,A2:A14,A15:A18)<\/code>do bu\u0148ky C15. Zde \u201eA2:A14\u201c st\u00e1le odkazuje na zn\u00e1m\u00e9 hodnoty x, zat\u00edmco \u201eB2:B14\u201c se t\u00fdk\u00e1 zn\u00e1m\u00fdch hodnot y.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"461\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-306-1.webp\" title=\"\" width=\"820\"\/><\/figure>\n<ul>\n<li>Stisknut\u00edm kl\u00e1vesy Enter z\u00edsk\u00e1te p\u0159edpokl\u00e1dan\u00e9 hodnoty pro budouc\u00ed obdob\u00ed.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"452\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-307-1.webp\" title=\"\" width=\"804\"\/><\/figure>\n<h2 id=\"trend-function-in-charts\">Za\u010dlen\u011bn\u00ed funkce TREND do graf\u016f<\/h2>\n<p>Po odvozen\u00ed dat pomoc\u00ed funkce TREND je m\u016f\u017eete vizualizovat ve form\u00e1tu grafu.<\/p>\n<ul>\n<li>Zv\u00fdrazn\u011bte v\u0161echna relevantn\u00ed data v listu v\u010detn\u011b z\u00e1hlav\u00ed a klikn\u011bte na z\u00e1lo\u017eku &#8216;Vlo\u017eit&#8217; um\u00edst\u011bnou naho\u0159e.<\/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\/10\/image-308-1.webp\" title=\"\" width=\"885\"\/><\/figure>\n<ul>\n<li>D\u00e1le z mo\u017enost\u00ed grafu vyberte &#8216;2D Clustered Column Chart&#8217;. V z\u00e1vislosti na va\u0161\u00ed verzi aplikace Excel se vzhled m\u016f\u017ee m\u00edrn\u011b li\u0161it.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"509\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-310-1.webp\" title=\"\" width=\"905\"\/><\/figure>\n<ul>\n<li>Jakmile je graf vytvo\u0159en, budete sledovat jak \u00fadaje o tr\u017eb\u00e1ch (nez\u00e1visl\u00e1 prom\u011bnn\u00e1), tak i trendovou linii. Chcete-li trendovou linii zn\u00e1zornit jako grafickou \u010d\u00e1ru, klikn\u011bte prav\u00fdm tla\u010d\u00edtkem na graf a vyberte \u201eZm\u011bnit typ grafu\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"477\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-311-1.webp\" title=\"\" width=\"848\"\/><\/figure>\n<ul>\n<li>Vyberte &#8216;Combo&#8217; z dostupn\u00fdch mo\u017enost\u00ed a ujist\u011bte se, \u017ee je trendov\u00e1 \u010d\u00e1ra nakonfigurov\u00e1na jako &#8216;Line&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"480\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-313-1.webp\" title=\"\" width=\"853\"\/><\/figure>\n<ul>\n<li>Kliknut\u00edm na &#8216;OK&#8217; vygenerujete aktualizovan\u00fd graf. Legendu m\u016f\u017eete tak\u00e9 odstranit kliknut\u00edm na ikonu &#8216;+&#8217; um\u00edst\u011bnou v rohu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"531\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/10\/image-314-1.webp\" title=\"\" width=\"944\"\/><\/figure>\n<p>Po vizualizaci trendu ve va\u0161\u00ed datov\u00e9 sad\u011b m\u00e1te mo\u017enost vypo\u010d\u00edtat sklon.<\/p>\n<h3 id=\"things-to-know\">D\u016fle\u017eit\u00e9 body k zapamatov\u00e1n\u00ed<\/h3>\n<ul>\n<li>Funkce TREND vyu\u017e\u00edv\u00e1 metodu podobnou metod\u011b funkce FORECAST; zam\u011b\u0159uje se v\u0161ak na minul\u00e1 data, zat\u00edmco FORECAST se pou\u017e\u00edv\u00e1 k p\u0159edpov\u00edd\u00e1n\u00ed budouc\u00edch hodnot v \u0159ad\u011b.<\/li>\n<li>Pokud nechcete ilustrovat budouc\u00ed p\u0159edpov\u011bdi, m\u016f\u017eete p\u0159idat spojnici trendu p\u0159\u00edmo do grafu v Excelu bez pou\u017eit\u00ed funkce TREND.<\/li>\n<li>Sparklines, dostupn\u00e9 na kart\u011b &#8216;Vlo\u017eit&#8217;, v\u00e1m poskytuj\u00ed dal\u0161\u00ed zp\u016fsob, jak vizualizovat trendy ve va\u0161ich datech.<\/li>\n<li>P\u0159i pr\u00e1ci se vzorci, kter\u00e9 vytv\u00e1\u0159ej\u00ed maticov\u00e9 v\u00fdstupy, je mus\u00edte zadat jako maticov\u00e9 vzorce pomoc\u00ed <code>Ctrl + Shift + Enter<\/code>. Naopak, pokud pou\u017e\u00edv\u00e1te aktualizovanou verzi Microsoft 365, bude sta\u010dit pouh\u00e9 stisknut\u00ed kl\u00e1vesy Enter.<\/li>\n<\/ul>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-trend-function-in-excel\/\" rel=\"noopener nofollow\" target=\"_blank\">Zdroj<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Funkce TREND v Excelu je v\u00fdkonn\u00fd n\u00e1stroj, kter\u00fd umo\u017e\u0148uje u\u017eivatel\u016fm vypo\u010d\u00edtat nejvhodn\u011bj\u0161\u00ed \u010d\u00e1ru pro data prezentovan\u00e1 v grafu pomoc\u00ed statistick\u00e9 metody nejmen\u0161\u00edch \u010dtverc\u016f. Z\u00e1kladn\u00ed rovnice pou\u017eit\u00e1 v t\u00e9to funkci je y = mx + b, kde y p\u0159edstavuje z\u00e1visle prom\u011bnnou, m je sklon p\u0159\u00edmky, x ozna\u010duje nez\u00e1vislou prom\u011bnnou a b ozna\u010duje bod, ve kter\u00e9m spojnice [&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-4759","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\/4759","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=4759"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/4759\/revisions"}],"predecessor-version":[{"id":4760,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/4759\/revisions\/4760"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=4759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=4759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=4759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}