{"id":3753,"date":"2022-12-18T21:49:51","date_gmt":"2022-12-18T21:49:51","guid":{"rendered":"https:\/\/global.tab-tv.com\/ro\/?p=3753"},"modified":"2022-12-18T21:49:55","modified_gmt":"2022-12-18T21:49:55","slug":"cum-sa-comutati-axele-x-si-y-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/global.tab-tv.com\/ro\/cum-sa-comutati-axele-x-si-y-in-microsoft-excel\/","title":{"rendered":"Cum s\u0103 comuta\u021bi axele X \u0219i Y \u00een Microsoft Excel"},"content":{"rendered":"\n<p>Microsoft Excel a fost mult timp cea mai popular\u0103 aplica\u021bie pentru crearea de pagini, diagrame, liste \u0219i alte lucruri pentru afaceri. Setul s\u0103u de instrumente este cel care v\u0103 permite s\u0103 crea\u021bi cu u\u0219urin\u021b\u0103 \u0219i rapid graficul potrivit \u0219i s\u0103 \u00eel personaliza\u021bi \u00een func\u021bie de nevoile dumneavoastr\u0103.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Exist\u0103 o op\u021biune pentru a schimba \u00eentre axele X \u0219i Y \u00een Excel<\/strong><\/h2>\n\n\n\n<p>\u00cen zilele noastre, aproape toat\u0103 lumea folose\u0219te Microsoft Office \u00een fiecare zi. De\u0219i majoritatea oamenilor pretind c\u0103 sunt competen\u021bi \u00een Office, acest lucru este departe de a fi adev\u0103rat. Excel, \u00een special, nu este nici pe departe u\u0219or de utilizat, mai ales dac\u0103 nu sunte\u021bi pricepu\u021bi la tehnologie. Atunci c\u00e2nd crea\u021bi grafice pe baza tabelelor Excel, programul calculeaz\u0103 automat valorile \u0219i construie\u0219te un grafic pe baza acestor calcule, dar exist\u0103 posibilitatea ca graficul creat automat s\u0103 fie incomod sau neatractiv. Pentru a remedia acest lucru, trebuie doar s\u0103 schimba\u021bi axele: axa X trebuie s\u0103 fie vertical\u0103, iar axa Y trebuie s\u0103 fie orizontal\u0103.<\/p>\n\n\n\n<p>Fie c\u0103 sunte\u021bi student, proprietar de afacere sau iubi\u021bi diagramele \u0219i graficele, trebuie s\u0103 \u0219ti\u021bi cum s\u0103 utiliza\u021bi Excel. Una dintre cele mai frecvente \u00eentreb\u0103ri legate de Excel este cum se modific\u0103 axa X \u0219i axa Y. A\u0219adar, iat\u0103 cum s\u0103 schimbi axa X \u0219i axa Y \u00een Microsoft Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Ce este o diagram\u0103 Axa<\/strong><\/h2>\n\n\n\n<p>Graficele din Excel nu sunt at\u00e2t de complicate dac\u0103 \u0219ti\u021bi la ce s\u0103 v\u0103 a\u0219tepta\u021bi. Exist\u0103 o ax\u0103 X \u0219i o ax\u0103 Y. Prima este orizontal\u0103, iar a doua este vertical\u0103. Atunci c\u00e2nd schimba\u021bi axa X orizontal\u0103, schimba\u021bi categoriile din cadrul acesteia. De asemenea, \u00eei pute\u021bi schimba scara pentru o vizualizare mai u\u0219oar\u0103.<\/p>\n\n\n\n<p>Pe axa orizontal\u0103 se afi\u0219eaz\u0103 fie data, fie un text care indic\u0103 diferite intervale de timp. Aceast\u0103 ax\u0103 nu este numeric\u0103 precum axa vertical\u0103. Axa vertical\u0103 arat\u0103 valoarea categoriilor corespunz\u0103toare. Pute\u021bi utiliza mai multe categorii, dar ave\u021bi grij\u0103 la dimensiunea graficului, astfel \u00eenc\u00e2t s\u0103 \u00eencap\u0103 pe pagina Excel. Cel mai bun num\u0103r de seturi de date pentru un grafic vizual Excel este de patru p\u00e2n\u0103 la \u0219ase. Dac\u0103 ave\u021bi mai multe date de afi\u0219at, poate le \u00eemp\u0103r\u021bi\u021bi \u00een mai multe grafice, ceea ce nu este dificil de f\u0103cut.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Cum s\u0103 comuta\u021bi axele X \u0219i Y \u00een Microsoft Excel<\/strong><\/h2>\n\n\n\n<p>Dac\u0103 dori\u021bi s\u0103 comuta\u021bi axele X \u0219i Y \u00een Microsoft Excel, trebuie s\u0103 urma\u021bi ace\u0219ti pa\u0219i:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00cen primul r\u00e2nd, face\u021bi clic dreapta pe una dintre axe \u0219i selecta\u021bi <strong>&#8222;Select Data&#8221;<\/strong>. \u00cen acest fel, pute\u021bi schimba \u0219i sursa de date pentru grafic.<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel.webp\" alt=\"\" class=\"wp-image-3754\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel.webp 774w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-300x176.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>\u00cen caseta de dialog <strong>&#8222;Select Data Source&#8221; (Selectare surs\u0103 de date)<\/strong>, pute\u021bi vedea valorile verticale, care reprezint\u0103 axa X. De asemenea, \u00een dreapta se afl\u0103 valorile orizontale, care reprezint\u0103 axa Y. Pentru a schimba axele, trebuie s\u0103 face\u021bi clic pe butonul <strong>&#8222;Edit&#8221; <\/strong>din st\u00e2nga.<\/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\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1.webp\" alt=\"\" class=\"wp-image-3755\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1.webp 859w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-1-300x131.webp 300w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Popup-ul arat\u0103 c\u0103 valorile seriei X se afl\u0103 \u00een intervalul <strong>&#8222;=Sheet1!$B$2:$B$10&#8221;, <\/strong>iar valorile seriei Y se afl\u0103 \u00een intervalul <strong>&#8222;=Sheet1!$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\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-2.webp\" alt=\"\" class=\"wp-image-3756\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-2.webp 423w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Pentru a schimba valorile, trebuie s\u0103 schimba\u021bi cele dou\u0103 intervale, astfel \u00eenc\u00e2t intervalul pentru seria X s\u0103 devin\u0103 intervalul pentru seria Y \u0219i invers. Astfel, \u00een valorile seriei X, introduce\u021bi &#8222;<strong>=Sheet1!$C$2:$C$10&#8243;, <\/strong>iar \u00een valorile seriei Y, introduce\u021bi <strong>&#8222;=Sheet1!$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\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-3.webp\" alt=\"\" class=\"wp-image-3757\" srcset=\"https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/2022\/12\/How-to-switch-X-and-Y-axis-in-Microsoft-Excel-3.webp 424w, https:\/\/global.tab-tv.com\/ro\/wp-content\/uploads\/sites\/2\/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>Apoi, confirma\u021bi modific\u0103rile, ve\u021bi fi redirec\u021bionat \u00eenapoi la fereastra <strong>&#8222;Select Data Source&#8221; <\/strong>\u0219i face\u021bi clic pe <strong>&#8222;OK&#8221;<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p>Dup\u0103 ce a\u021bi finalizat ace\u0219ti pa\u0219i, axele X \u0219i T vor fi comutate.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><a><\/a><strong>Cum se schimb\u0103 scara axei Y \u00een Excel<\/strong><\/h2>\n\n\n\n<p>\u00cen cazul \u00een care ave\u021bi nevoie s\u0103 reduce\u021bi pu\u021bin intervalul pentru a v\u0103 concentra pe un anumit interval sau s\u0103 inversa\u021bi ordinea axei, iat\u0103 un ghid:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00cen graficul dvs., face\u021bi clic pe <strong><em>&#8222;axa Y&#8221; pe care <\/em><\/strong>dori\u021bi s\u0103 o modifica\u021bi. Aceasta va afi\u0219a o margine pentru a reprezenta faptul c\u0103 este eviden\u021biat\u0103\/selectat\u0103.<\/li>\n\n\n\n<li>Face\u021bi clic pe fila <strong><em>&#8222;Format&#8221;<\/em><\/strong>, apoi alege\u021bi <strong><em>&#8222;Format Selection&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Se afi\u0219eaz\u0103 caseta de dialog &#8222;Format Axis&#8221;.<\/li>\n\n\n\n<li>Pentru a modifica valorile de \u00eenceput \u0219i de sf\u00e2r\u0219it sau valorile minime \u0219i maxime, merge\u021bi la sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Bounds&#8221; (Op\u021biuni ax\u0103 -&gt; Limite)<\/em><\/strong>, apoi introduce\u021bi un nou num\u0103r \u00een c\u0103su\u021bele <strong><em>&#8222;Minimum&#8221; <\/em><\/strong>\u0219i <strong><em>&#8222;Maximum&#8221;. Dac\u0103 <\/em><\/strong>trebuie s\u0103 anula\u021bi modificarea, face\u021bi clic pe <strong><em>&#8222;Reset&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Pentru a modifica intervalul\/spa\u021bierea marcajelor sau a liniilor de gril\u0103, merge\u021bi la sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Units&#8221; (Op\u021biuni ax\u0103 -&gt; Unit\u0103\u021bi)<\/em><\/strong>, apoi introduce\u021bi un num\u0103r nou \u00een op\u021biunea <strong><em>&#8222;Major unit&#8221; (Unitate major\u0103) <\/em><\/strong>sau &#8222;<strong><em>Minor unit&#8221; (Unitate minor\u0103), \u00een <\/em><\/strong>func\u021bie de necesit\u0103\u021bi. Dac\u0103 trebuie s\u0103 anula\u021bi modificarea, face\u021bi clic pe <strong><em>&#8222;Reset&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Pentru a modifica punctul de intersec\u021bie al axelor X \u0219i Y, merge\u021bi la op\u021biunea <strong>&#8222;Axis Options -&gt; Vertical axis crosses&#8221; (Op\u021biuni ax\u0103 -&gt; Cruce ax\u0103 vertical\u0103)<\/strong>, apoi alege\u021bi <strong><em>&#8222;Automatic&#8221; (Automat), &#8222;Axis value&#8221; (Valoarea axei) <\/em><\/strong>sau <strong><em>&#8222;Maximum axis value&#8221; (Valoarea maxim\u0103 a axei).<\/em><\/strong> Dac\u0103 alege\u021bi &#8222;Axis value&#8221; (Valoarea axei), introduce\u021bi valoarea care dori\u021bi s\u0103 devin\u0103 punctul de intersec\u021bie.<\/li>\n\n\n\n<li>Pentru a modifica unit\u0103\u021bile afi\u0219ate, cum ar fi schimbarea 1.000.000 \u00een 1, unde unit\u0103\u021bile reprezint\u0103 milioane, accesa\u021bi sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Display units&#8221;. <\/em><\/strong>Face\u021bi clic pe lista derulant\u0103 de l\u00e2ng\u0103 <strong><em>&#8222;Display Units&#8221; (Unit\u0103\u021bi de afi\u0219are), <\/em><\/strong>apoi face\u021bi selec\u021bia, cum ar fi <strong><em>&#8222;milioane&#8221; <\/em><\/strong>sau <strong><em>&#8222;sute&#8221;.<\/em><\/strong><\/li>\n\n\n\n<li>Pentru a eticheta unit\u0103\u021bile afi\u0219ate, merge\u021bi la sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Display units&#8221; (Op\u021biuni ax\u0103 -&gt; Unit\u0103\u021bi de afi\u0219are). <\/em><\/strong>Ad\u0103uga\u021bi o bif\u0103 \u00een caseta <strong><em>&#8222;Show display units label on chart&#8221; (Afi\u0219a\u021bi eticheta unit\u0103\u021bilor de afi\u0219are pe grafic)<\/em><\/strong>, apoi introduce\u021bi <strong><em>&#8222;eticheta unit\u0103\u021bilor&#8221;, <\/em><\/strong>cum ar fi &#8222;Numbers based in millions&#8221; (Numere bazate pe milioane).<\/li>\n\n\n\n<li>Pentru a comuta axa valorilor pe o scar\u0103 logaritmic\u0103, accesa\u021bi sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Display units&#8221; (Op\u021biuni ax\u0103 -&gt; Unit\u0103\u021bi de afi\u0219are), <\/em><\/strong>apoi ad\u0103uga\u021bi o bif\u0103 \u00een caseta <strong><em>&#8222;Logarithmic scale&#8221; (Scar\u0103 logaritmic\u0103).<\/em><\/strong><\/li>\n\n\n\n<li>Pentru a inversa ordinea valorilor verticale, merge\u021bi la sec\u021biunea <strong><em>&#8222;Axis Options -&gt; Display units&#8221; (Op\u021biuni ax\u0103 -&gt; Unit\u0103\u021bi de afi\u0219are)<\/em><\/strong>, apoi ad\u0103uga\u021bi o bif\u0103 \u00een caseta <strong><em>&#8222;Values in reverse order&#8221; (Valori \u00een ordine invers\u0103).<\/em><\/strong> Aceast\u0103 ac\u021biune inverseaz\u0103, de asemenea, axa orizontal\u0103 pentru a reflecta acurate\u021bea \u00een diagrama sau graficul dvs.<\/li>\n\n\n\n<li>Pentru a ajusta amplasarea marcajelor, accesa\u021bi sec\u021biunea <strong><em>&#8222;Marcaje de bifurca\u021bie&#8221;. Face\u021bi <\/em><\/strong>clic pe pic\u0103turile de l\u00e2ng\u0103 <strong><em>&#8222;Major Type&#8221; <\/em><\/strong>\u0219i &#8222;<strong><em>Minor type&#8221;, <\/em><\/strong>apoi face\u021bi selec\u021bia.<\/li>\n\n\n\n<li>Pentru a modifica pozi\u021bia etichetei axei, merge\u021bi la sec\u021biunea <strong><em>&#8222;Labels&#8221; (Etichete). Face\u021bi <\/em><\/strong>clic pe lista derulant\u0103 de l\u00e2ng\u0103 <strong><em>&#8222;Label Position&#8221; (Pozi\u021bia etichetei), <\/em><\/strong>apoi face\u021bi selec\u021bia.<\/li>\n<\/ul>\n\n\n\n<p>Acum \u0219ti\u021bi mai multe despre cum s\u0103 v\u0103 gestiona\u021bi propriet\u0103\u021bile Excel \u0219i s\u0103 v\u0103 u\u0219ura\u021bi munca.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel a fost mult timp cea mai popular\u0103 aplica\u021bie pentru crearea de pagini, diagrame, liste \u0219i alte lucruri pentru afaceri. Setul s\u0103u de instrumente este cel care v\u0103 permite s\u0103 crea\u021bi cu u\u0219urin\u021b\u0103 \u0219i rapid graficul potrivit \u0219i s\u0103 \u00eel personaliza\u021bi \u00een func\u021bie de nevoile dumneavoastr\u0103. Exist\u0103 o op\u021biune pentru a schimba \u00eentre axele [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3758,"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":[29],"class_list":{"0":"post-3753","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ghiduri","8":"tag-microsoft-excel"},"_links":{"self":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/3753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/comments?post=3753"}],"version-history":[{"count":1,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/3753\/revisions"}],"predecessor-version":[{"id":3759,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/posts\/3753\/revisions\/3759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/media\/3758"}],"wp:attachment":[{"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/media?parent=3753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/categories?post=3753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global.tab-tv.com\/ro\/wp-json\/wp\/v2\/tags?post=3753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}