{"id":560,"date":"2022-09-20T12:08:00","date_gmt":"2022-09-20T10:08:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=560"},"modified":"2022-09-21T15:12:40","modified_gmt":"2022-09-21T13:12:40","slug":"extra-diagramtipp","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/","title":{"rendered":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal"},"content":{"rendered":"\n<p>Mit tegy\u00e9l, ha\u00a0\u00e9vsz\u00e1m szerepel a t\u00e1bl\u00e1zatban, amit adatnak \u00e9rz\u00e9kel az Excel, \u00e9s emiatt nem j\u00f3 helyre ker\u00fclnek a diagramon a feliratok &#8211; \u00e9s az \u00e9vsz\u00e1mokat is \u00e1br\u00e1zolja az Excel.<\/p>\n\n\n\n<p>M\u00e1s t\u00e1bl\u00e1zatokn\u00e1l \u00fcgyesen felismeri az Excel, hogy mi hova ker\u00fcl, \u00edgy <a href=\"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/\" data-type=\"post\" data-id=\"3326\" target=\"_blank\" rel=\"noreferrer noopener\">a diagramk\u00e9sz\u00edt\u00e9s rendk\u00edv\u00fcl egyszer\u0171.<\/a><\/p>\n\n\n\n<p>Erre az esetre&nbsp;2 megold\u00e1s van:<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\"><strong>1) Elk\u00e9sz\u00edted a diagramot az \u00e9vsz\u00e1mok n\u00e9lk\u00fcl, \u00e9s ut\u00f3lag illeszted be az \u00e9vsz\u00e1mokat<\/strong><\/h2>\n\n\n\n<p>Csak az adatsorokat jel\u00f6ld ki, fejl\u00e9c (\u00e9vsz\u00e1mok) n\u00e9lk\u00fcl, \u00e9s \u00fagy sz\u00fard be a diagramot.<\/p>\n\n\n\n<p>Ilyenkor 1, 2, 3, stb jelenik meg feliratk\u00e9nt, vagy Adatsor1, 2, 3 jelmagyar\u00e1zatk\u00e9nt. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"611\" height=\"425\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\" alt=\"\" class=\"wp-image-9637\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png 611w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul-300x209.png 300w\" sizes=\"(max-width: 611px) 100vw, 611px\" \/><\/a><\/figure>\n\n\n\n<p>Ennek lecser\u00e9l\u00e9s\u00e9hez kattints a Diagrameszk\u00f6z\u00f6k men\u00fcn az Adatok kijel\u00f6l\u00e9se gombra. (A diagramon jobbklikkel is el\u00e9rheted a funkci\u00f3t.)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/savdiagram-evszam-nelkul.png\"><img decoding=\"async\" width=\"614\" height=\"422\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/savdiagram-evszam-nelkul.png\" alt=\"\" class=\"wp-image-9638\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/savdiagram-evszam-nelkul.png 614w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/savdiagram-evszam-nelkul-300x206.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/><\/a><\/figure>\n\n\n\n<p>Itt l\u00e1thatod, hogy a V\u00edzszintes tengely feliratokn\u00e1l (jobb ablakban) 1-t\u0151l X-ig szerepelnek a sz\u00e1mok. Kattints a Szerkeszt\u00e9s gombra \u00e9s megjelenik a Tengelyfeliratok ablak. Az eg\u00e9r seg\u00edts\u00e9g\u00e9vel jel\u00f6ld ki azt az X sz\u00e1mot, amit feliratk\u00e9nt szeretn\u00e9l l\u00e1tni a diagramon. Az Adatsor neveit (bal ablakban) csak egyes\u00e9vel tudod cser\u00e9lni, ezt a lenti f\u00e1jlon ki is pr\u00f3b\u00e1lhatod.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>2) Egyszer\u0171bb, de tr\u00fckk\u00f6sebb megold\u00e1s<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:40% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2022\/09\/diagram-evszam-trukkos-kijeloles.png\" alt=\"\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Az adatok kijel\u00f6l\u00e9se el\u0151tt t\u00f6r\u00f6ld ki a a 2 tengely k\u00f6z\u00f6tti cell\u00e1ban (bal fels\u0151 sarok) tal\u00e1lhat\u00f3 elnevez\u00e9st, mint az \u00e1bra mutatja. Az \u00fcres cell\u00e1val egy\u00fctt jel\u00f6ld ki a feliratokat \u00e9s az adatokat, \u00e9s \u00edgy sz\u00fard be a megfelel\u0151 diagramot.<\/p>\n\n\n\n<p>\u00cdgy minden mag\u00e1t\u00f3l a hely\u00e9re ker\u00fcl.<\/p>\n\n\n\n<p>Persze a diagram elk\u00e9sz\u00edt\u00e9se ut\u00e1n vissza\u00edrhatod az \u00fcres cell\u00e1ba a sz\u00f6veget.<\/p>\n<\/div><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pr\u00f3b\u00e1ld ki a gyakorlatban<\/h2>\n\n\n\n<p>T\u00f6ltsd le a t\u00e1bl\u00e1zatot, \u00e9s k\u00e9sz\u00edts az adatokb\u00f3l s\u00e1vdiagramot: <a href=\"http:\/\/exceltitok.hu\/rend\/diagram.xlsx\">excel<\/a><\/p>\n\n\n\n<p>Itt is az \u00e9vsz\u00e1mok miatt van a gond, ez\u00e9rt lesz a jelmagyar\u00e1zatban Sorozatok 1, 2, stb.<\/p>\n\n\n\n<p>A&nbsp;sorozatok elnevez\u00e9shez kattints az Adatok kijel\u00f6l\u00e9se gombra, majd v\u00e1laszd ki az els\u0151 sorozatot \u00e9s kattints a Szerkeszt\u00e9s&nbsp;gombra. Mivel ez a sorozat a B3 cell\u00e1t\u00f3l a B23 cell\u00e1kig \u00e1br\u00e1zolja az adatokat, ez\u00e9rt ez az 1985-\u00f6s sorozat lesz.<\/p>\n\n\n\n<p>Az &#8216;Adatsor nev\u00e9t&#8217; be\u00edrhatod karakterekkel (1985),\u00a0vagy kijel\u00f6l\u00e9ssel \u00fagy, hogy a B2 cell\u00e1ra kattintasz. Ugyan\u00edgy nevezd el a t\u00f6bbi sorozatot is.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s.png\"><img decoding=\"async\" width=\"943\" height=\"451\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s.png\" alt=\"diagram-sorozat-szerkeszt\u00e9s\" class=\"wp-image-2214\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s.png 943w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s-300x143.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s-660x316.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/05\/diagram-sorozat-szerkeszt\u00e9s-240x115.png 240w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Term\u00e9szetesen itt is egyszer\u0171bb a fenti tr\u00fckk\u00f6s verzi\u00f3, pr\u00f3b\u00e1ld ki azt is!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2022\/09\/diagram-helyes-felirat-evszam.png\" alt=\"\" width=\"756\" height=\"413\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Ha seg\u00edts\u00e9g kell az Excel tanul\u00e1shoz<\/h2>\n\n\n\n<p>Ha szorgalmas vagy \u00e9s szeretsz \u00f6n\u00e1ll\u00f3an tanulni, szeretn\u00e9l hasznos tippeket, billenty\u0171kombin\u00e1ci\u00f3kat \u00e9s f\u00fcggv\u00e9nyeket tanulni, akkor rendeld meg az&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>. A gyakorl\u00e1shoz aj\u00e1nlom a kimondottan&nbsp;<a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>kezd\u0151knek k\u00e9sz\u00fclt feladatsorokat<\/strong><\/a>.<\/p>\n\n\n\n<p>Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>! Ha egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n\n\n\n<p>Vagy gyere a VIP Klubba, ahol&nbsp;<strong>hasonl\u00f3 \u00e9rdekes megold\u00e1sokat tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz \u2013 \u00edgy egy biztos h\u00e1tt\u00e9rrel a saj\u00e1t temp\u00f3dban haladhatsz:&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/vip-klub-2021\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel VIP Klub<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mit tegy\u00e9l, ha\u00a0\u00e9vsz\u00e1m szerepel a t\u00e1bl\u00e1zatban, amit adatnak \u00e9rz\u00e9kel az Excel, \u00e9s emiatt nem j\u00f3 helyre ker\u00fclnek a diagramon a feliratok &#8211; \u00e9s az \u00e9vsz\u00e1mokat is \u00e1br\u00e1zolja az Excel. M\u00e1s t\u00e1bl\u00e1zatokn\u00e1l \u00fcgyesen felismeri az Excel, hogy mi hova ker\u00fcl, \u00edgy a diagramk\u00e9sz\u00edt\u00e9s rendk\u00edv\u00fcl egyszer\u0171. Erre az esetre&nbsp;2 megold\u00e1s van:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[36],"class_list":["post-560","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-diagram"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"robots\" content=\"noindex, nofollow\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Mit tegy\u00e9l, ha\u00a0\u00e9vsz\u00e1m szerepel a t\u00e1bl\u00e1zatban, amit adatnak \u00e9rz\u00e9kel az Excel, \u00e9s emiatt nem j\u00f3 helyre ker\u00fclnek a diagramon a feliratok &#8211; \u00e9s az \u00e9vsz\u00e1mokat is \u00e1br\u00e1zolja az Excel. M\u00e1s t\u00e1bl\u00e1zatokn\u00e1l \u00fcgyesen felismeri az Excel, hogy mi hova ker\u00fcl, \u00edgy a diagramk\u00e9sz\u00edt\u00e9s rendk\u00edv\u00fcl egyszer\u0171. Erre az esetre&nbsp;2 megold\u00e1s van:\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-20T10:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-21T13:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal\",\"datePublished\":\"2022-09-20T10:08:00+00:00\",\"dateModified\":\"2022-09-21T13:12:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\"},\"wordCount\":596,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\",\"keywords\":[\"diagram\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\",\"name\":\"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\",\"datePublished\":\"2022-09-20T10:08:00+00:00\",\"dateModified\":\"2022-09-21T13:12:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png\",\"width\":611,\"height\":425},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","robots":{"index":"noindex","follow":"nofollow"},"og_locale":"hu_HU","og_type":"article","og_title":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Mit tegy\u00e9l, ha\u00a0\u00e9vsz\u00e1m szerepel a t\u00e1bl\u00e1zatban, amit adatnak \u00e9rz\u00e9kel az Excel, \u00e9s emiatt nem j\u00f3 helyre ker\u00fclnek a diagramon a feliratok &#8211; \u00e9s az \u00e9vsz\u00e1mokat is \u00e1br\u00e1zolja az Excel. M\u00e1s t\u00e1bl\u00e1zatokn\u00e1l \u00fcgyesen felismeri az Excel, hogy mi hova ker\u00fcl, \u00edgy a diagramk\u00e9sz\u00edt\u00e9s rendk\u00edv\u00fcl egyszer\u0171. Erre az esetre&nbsp;2 megold\u00e1s van:","og_url":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2022-09-20T10:08:00+00:00","article_modified_time":"2022-09-21T13:12:40+00:00","og_image":[{"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal","datePublished":"2022-09-20T10:08:00+00:00","dateModified":"2022-09-21T13:12:40+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/"},"wordCount":596,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png","keywords":["diagram"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/","url":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/","name":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png","datePublished":"2022-09-20T10:08:00+00:00","dateModified":"2022-09-21T13:12:40+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/09\/oszlopdiagram-tengely-evszam-nelkul.png","width":611,"height":425},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/extra-diagramtipp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Diagramk\u00e9sz\u00edt\u00e9s \u00e9vsz\u00e1mokkal"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/560","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=560"}],"version-history":[{"count":15,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":9639,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/560\/revisions\/9639"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}