{"id":3727,"date":"2022-12-18T21:52:48","date_gmt":"2022-12-18T21:52:48","guid":{"rendered":"https:\/\/global.tab-tv.com\/sk\/?p=3727"},"modified":"2022-12-18T21:52:50","modified_gmt":"2022-12-18T21:52:50","slug":"ako-prepinat-osi-x-a-y-v-programe-microsoft-excel","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/sk\/ako-prepinat-osi-x-a-y-v-programe-microsoft-excel\/","title":{"rendered":"Ako prep\u00edna\u0165 osi X a Y v programe Microsoft Excel"},"content":{"rendered":"\n<p>Microsoft Excel je u\u017e dlho najob\u013e\u00fabenej\u0161ou aplik\u00e1ciou na vytv\u00e1ranie str\u00e1nok, grafov, zoznamov a \u010fal\u0161\u00edch vec\u00ed na podnikanie. Pr\u00e1ve jeho s\u00fabor n\u00e1strojov v\u00e1m umo\u017e\u0148uje jednoducho a r\u00fdchlo vytvori\u0165 spr\u00e1vny graf a prisp\u00f4sobi\u0165 ho svojim potreb\u00e1m.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Existuje mo\u017enos\u0165 v\u00fdmeny medzi osami X a Y v programe Excel<\/strong><\/h2>\n\n\n\n<p>V dne\u0161nej dobe takmer ka\u017ed\u00fd denne pou\u017e\u00edva bal\u00edk Microsoft Office. Hoci v\u00e4\u010d\u0161ina \u013eud\u00ed tvrd\u00ed, \u017ee ovl\u00e1da Office, z\u010faleka to tak nie je. Najm\u00e4 Excel nie je ani z\u010faleka jednoduch\u00e9 pou\u017e\u00edva\u0165, najm\u00e4 ak nie ste technicky zdatn\u00ed. Pri vytv\u00e1ran\u00ed grafov na z\u00e1klade tabuliek programu Excel program automaticky vypo\u010d\u00edta hodnoty a na z\u00e1klade t\u00fdchto v\u00fdpo\u010dtov zostav\u00ed graf, ale existuje mo\u017enos\u0165, \u017ee automaticky vytvoren\u00fd graf bude nepohodln\u00fd alebo neatrakt\u00edvny. Ak to chcete napravi\u0165, sta\u010d\u00ed vymeni\u0165 osi: os X by mala by\u0165 vertik\u00e1lna a os Y by mala by\u0165 horizont\u00e1lna.<\/p>\n\n\n\n<p>\u010ci u\u017e ste \u0161tudent, majite\u013e firmy alebo milujete grafy a diagramy, mus\u00edte vedie\u0165 pou\u017e\u00edva\u0165 Excel. Jednou z naj\u010dastej\u0161ie kladen\u00fdch ot\u00e1zok o programe Excel je, ako zmeni\u0165 os X a os Y. Tu teda n\u00e1jdete n\u00e1vod, ako prep\u00edna\u0165 osi X a Y v programe Microsoft Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>\u010co je os grafu<\/strong><\/h2>\n\n\n\n<p>Grafy v programe Excel nie s\u00fa a\u017e tak\u00e9 zlo\u017eit\u00e9, ak viete, \u010do m\u00e1te o\u010dak\u00e1va\u0165. Existuje os X a os Y. Prv\u00e1 je horizont\u00e1lna a druh\u00e1 vertik\u00e1lna. Ke\u010f zmen\u00edte horizont\u00e1lnu os X, zmen\u00edte kateg\u00f3rie v r\u00e1mci nej. M\u00f4\u017eete tie\u017e zmeni\u0165 jej mierku pre jednoduch\u0161ie zobrazenie.<\/p>\n\n\n\n<p>Na vodorovnej osi sa zobrazuje bu\u010f d\u00e1tum, alebo text zobrazuj\u00faci r\u00f4zne \u010dasov\u00e9 intervaly. T\u00e1to os nie je \u010d\u00edseln\u00e1 ako vertik\u00e1lna os. Na zvislej osi sa zobrazuje hodnota pr\u00edslu\u0161n\u00fdch kateg\u00f3ri\u00ed. M\u00f4\u017eete pou\u017ei\u0165 ve\u013ea kateg\u00f3ri\u00ed, ale dbajte na ve\u013ekos\u0165 grafu, aby sa zmestil na str\u00e1nku programu Excel. Najlep\u0161\u00ed po\u010det s\u00faborov \u00fadajov pre vizu\u00e1lny graf programu Excel je \u0161tyri a\u017e \u0161es\u0165. Ak m\u00e1te viac \u00fadajov na zobrazenie, mo\u017eno ich rozde\u013ete do viacer\u00fdch grafov, \u010do nie je \u0165a\u017ek\u00e9 urobi\u0165.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako prep\u00edna\u0165 osi X a Y v programe Microsoft Excel<\/strong><\/h2>\n\n\n\n<p>Ak chcete v programe Microsoft Excel prep\u00edna\u0165 osi X a Y, mus\u00edte postupova\u0165 pod\u013ea nasleduj\u00facich krokov:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Najprv kliknite prav\u00fdm tla\u010didlom my\u0161i na jednu z os\u00ed a vyberte polo\u017eku <strong>&#8220;Vybra\u0165 \u00fadaje&#8221;<\/strong>. Takto m\u00f4\u017eete zmeni\u0165 aj zdroj \u00fadajov pre graf.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"453\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel.webp\" alt=\"\" class=\"wp-image-3728\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel.webp 774w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-300x176.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-768x449.webp 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V dial\u00f3govom okne <strong>&#8220;Vybra\u0165 zdroj \u00fadajov&#8221; <\/strong>m\u00f4\u017eete vidie\u0165 vertik\u00e1lne hodnoty, ktor\u00e9 s\u00fa osou X. Vpravo s\u00fa tie\u017e vodorovn\u00e9 hodnoty, ktor\u00e9 predstavuj\u00fa os Y. Ak chcete prep\u00edna\u0165 osi, mus\u00edte klikn\u00fa\u0165 na tla\u010didlo <strong>&#8220;Upravi\u0165&#8221; <\/strong>v\u013eavo.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"859\" height=\"376\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1.webp\" alt=\"\" class=\"wp-image-3729\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1.webp 859w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1-300x131.webp 300w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1-768x336.webp 768w\" sizes=\"auto, (max-width: 859px) 100vw, 859px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vo vyskakovacom okne sa zobraz\u00ed, \u017ee hodnoty radu X s\u00fa v rozsahu <strong>&#8220;=List1!$B$2:$B$10&#8221; <\/strong>a hodnoty radu Y s\u00fa v rozsahu <strong>&#8220;=List1!$C$2:$C$10&#8221;<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"423\" height=\"253\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-2.webp\" alt=\"\" class=\"wp-image-3730\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-2.webp 423w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-2-300x179.webp 300w\" sizes=\"auto, (max-width: 423px) 100vw, 423px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ak chcete zmeni\u0165 hodnoty, mus\u00edte vymeni\u0165 oba rozsahy tak, aby sa rozsah pre rad X stal rozsahom pre rad Y a naopak. Tak\u017ee do hodn\u00f4t radu X zadajte <strong>&#8220;=List1!$C$2:$C$10&#8221; <\/strong>a do hodn\u00f4t radu Y zadajte <strong>&#8220;=List1!$B$2:$B$10&#8221;<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"424\" height=\"254\" src=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-3.webp\" alt=\"\" class=\"wp-image-3731\" srcset=\"https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-3.webp 424w, https:\/\/global.tab-tv.com\/sk\/wp-content\/uploads\/sites\/5\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-3-300x180.webp 300w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Potom potvr\u010fte zmeny, budete presmerovan\u00ed sp\u00e4\u0165 do okna <strong>&#8220;Select Data Source&#8221; <\/strong>a kliknite na tla\u010didlo <strong>&#8220;OK&#8221;<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>Po dokon\u010den\u00ed t\u00fdchto krokov sa prepn\u00fa osi X a T.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ako zmeni\u0165 mierku osi Y v programe Excel<\/strong><\/h2>\n\n\n\n<p>V pr\u00edpade, \u017ee potrebujete trochu zn\u00ed\u017ei\u0165 rozsah, aby ste sa zamerali na konkr\u00e9tny rozsah, alebo zmeni\u0165 poradie os\u00ed, tu je n\u00e1vod:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>V grafe kliknite na <strong><em>os Y, ktor\u00fa <\/em><\/strong>chcete zmeni\u0165. Zobraz\u00ed sa ohrani\u010denie, ktor\u00e9 zn\u00e1zor\u0148uje, \u017ee je zv\u00fdraznen\u00e1\/vybran\u00e1.<\/li>\n\n\n\n<li>Kliknite na kartu <strong><em>&#8220;Form\u00e1t&#8221; a <\/em><\/strong>potom vyberte mo\u017enos\u0165 <strong><em>&#8220;Form\u00e1tova\u0165 v\u00fdber&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Zobraz\u00ed sa dial\u00f3gov\u00e9 okno &#8220;Form\u00e1tova\u0165 os&#8221;.<\/li>\n\n\n\n<li>Ak chcete zmeni\u0165 po\u010diato\u010dn\u00e9 a koncov\u00e9 alebo minim\u00e1lne a maxim\u00e1lne hodnoty, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Hranice&#8221; <\/em><\/strong>a potom zadajte nov\u00e9 \u010d\u00edslo do pol\u00ed <strong><em>&#8220;Minimum&#8221; <\/em><\/strong>a <strong><em>&#8220;Maximum&#8221;. <\/em><\/strong>Ak potrebujete zmenu vr\u00e1ti\u0165 sp\u00e4\u0165, kliknite na <strong><em>&#8220;Resetova\u0165&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Ak chcete zmeni\u0165 interval\/rozostup zna\u010diek alebo \u010diar mrie\u017eky, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Jednotky&#8221; <\/em><\/strong>a potom zadajte nov\u00e9 \u010d\u00edslo do mo\u017enosti <strong><em>&#8220;Hlavn\u00e1 jednotka&#8221; <\/em><\/strong>alebo <strong><em>&#8220;Ved\u013eaj\u0161ia jednotka&#8221; <\/em><\/strong>v z\u00e1vislosti od va\u0161ich potrieb. Ak potrebujete zmenu vr\u00e1ti\u0165 sp\u00e4\u0165, kliknite na <strong><em>&#8220;Resetova\u0165&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Ak chcete zmeni\u0165 kr\u00ed\u017eov\u00fd bod os\u00ed X a Y, prejdite na mo\u017enos\u0165 <strong>&#8220;Mo\u017enosti osi -&gt; Zvisl\u00e9 kr\u00ed\u017ee os\u00ed&#8221; <\/strong>a potom vyberte mo\u017enos\u0165 <strong><em>&#8220;Automaticky&#8221;, &#8220;Hodnota osi&#8221; <\/em><\/strong>alebo <strong><em>&#8220;Maxim\u00e1lna hodnota osi&#8221;.<\/em><\/strong> Ak vyberiete mo\u017enos\u0165 &#8220;Hodnota osi&#8221;, zadajte hodnotu, ktor\u00e1 sa m\u00e1 sta\u0165 kr\u00ed\u017eov\u00fdm bodom.<\/li>\n\n\n\n<li>Ak chcete zmeni\u0165 zobrazen\u00e9 jednotky, napr\u00edklad zmeni\u0165 1 000 000 na 1, kde jednotky predstavuj\u00fa mili\u00f3ny, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Zobrazenie jednotiek&#8221;. <\/em><\/strong>Kliknite na rozba\u013eovac\u00ed zoznam ved\u013ea polo\u017eky <strong><em>&#8220;Zobrazovacie jednotky&#8221; a <\/em><\/strong>potom vykonajte v\u00fdber, napr\u00edklad <strong><em>&#8220;mili\u00f3ny&#8221; <\/em><\/strong>alebo <strong><em>&#8220;stovky&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Ak chcete ozna\u010di\u0165 zobrazen\u00e9 jednotky, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Zobrazenie jednotiek&#8221;. <\/em><\/strong>Pridajte za\u010diarknutie do pol\u00ed\u010dka <strong><em>&#8220;Zobrazi\u0165 ozna\u010denie zobrazovan\u00fdch jednotiek na grafe&#8221; <\/em><\/strong>a potom zadajte <strong><em>&#8220;ozna\u010denie jednotiek&#8221;, <\/em><\/strong>napr\u00edklad &#8220;\u010c\u00edsla v mili\u00f3noch&#8221;.<\/li>\n\n\n\n<li>Ak chcete prepn\u00fa\u0165 os hodn\u00f4t na logaritmick\u00fa stupnicu, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Jednotky zobrazenia&#8221; <\/em><\/strong>a potom pridajte za\u010diarknutie do pol\u00ed\u010dka <strong><em>&#8220;Logaritmick\u00e1 stupnica&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Ak chcete obr\u00e1ti\u0165 poradie vertik\u00e1lnych hodn\u00f4t, prejdite do \u010dasti <strong><em>&#8220;Mo\u017enosti osi -&gt; Jednotky zobrazenia&#8221; <\/em><\/strong>a potom pridajte za\u010diarknutie do pol\u00ed\u010dka <strong><em>&#8220;Hodnoty v obr\u00e1tenom porad\u00ed&#8221;.<\/em><\/strong> T\u00e1to akcia tie\u017e obr\u00e1ti vodorovn\u00fa os, aby odr\u00e1\u017eala presnos\u0165 v grafe alebo tabu\u013eke.<\/li>\n\n\n\n<li>Ak chcete upravi\u0165 umiestnenie zna\u010diek za\u0161krtnutia, prejdite do \u010dasti <strong><em>&#8220;Zna\u010dky za\u0161krtnutia&#8221;. <\/em><\/strong>Kliknite na rozba\u013eovacie zoznamy ved\u013ea polo\u017eiek <strong><em>&#8220;Major Type&#8221; (Hlavn\u00fd typ) <\/em><\/strong>a <strong><em>&#8220;Minor type&#8221; (Ved\u013eaj\u0161\u00ed typ) a <\/em><\/strong>potom vykonajte v\u00fdber.<\/li>\n\n\n\n<li>Ak chcete zmeni\u0165 polohu \u0161t\u00edtku osi, prejdite do \u010dasti <strong><em>&#8220;\u0160t\u00edtky&#8221;. <\/em><\/strong>Kliknite na rozba\u013eovac\u00ed zoznam ved\u013ea polo\u017eky <strong><em>&#8220;Label Position&#8221; (Poz\u00edcia \u0161t\u00edtku) a <\/em><\/strong>potom vykonajte v\u00fdber.<\/li>\n<\/ul>\n\n\n\n<p>Teraz u\u017e viete viac o tom, ako spravova\u0165 vlastnosti aplik\u00e1cie Excel a u\u013eah\u010di\u0165 si pr\u00e1cu.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel je u\u017e dlho najob\u013e\u00fabenej\u0161ou aplik\u00e1ciou na vytv\u00e1ranie str\u00e1nok, grafov, zoznamov a \u010fal\u0161\u00edch vec\u00ed na podnikanie. Pr\u00e1ve jeho s\u00fabor n\u00e1strojov v\u00e1m umo\u017e\u0148uje jednoducho a r\u00fdchlo vytvori\u0165 spr\u00e1vny graf a prisp\u00f4sobi\u0165 ho svojim potreb\u00e1m. Existuje mo\u017enos\u0165 v\u00fdmeny medzi osami X a Y v programe Excel V dne\u0161nej dobe takmer ka\u017ed\u00fd denne pou\u017e\u00edva bal\u00edk Microsoft Office. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3732,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2],"tags":[30],"class_list":{"0":"post-3727","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sprievodcovia","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/3727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/comments?post=3727"}],"version-history":[{"count":1,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/3727\/revisions"}],"predecessor-version":[{"id":3733,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/posts\/3727\/revisions\/3733"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media\/3732"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/media?parent=3727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/categories?post=3727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/sk\/wp-json\/wp\/v2\/tags?post=3727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}