{"id":3326,"date":"2016-04-11T19:55:49","date_gmt":"2016-04-11T17:55:49","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=3326"},"modified":"2020-07-05T02:47:02","modified_gmt":"2020-07-05T00:47:02","slug":"a-profi-diagram-keszites-lepesei","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/","title":{"rendered":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei"},"content":{"rendered":"<p><strong>A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog<\/strong>, sokszor ink\u00e1bb az a k\u00e9rd\u00e9s,\u00a0hogy melyik diagram-t\u00edpus a legmegfelel\u0151bb a\u00a0szeml\u00e9ltet\u00e9shez.<\/p>\n<p>Az <a href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-kulonbseg-a-csoportositott-es-a-halmozott-oszlop-diagram-kozott\/\" target=\"_blank\" rel=\"noopener noreferrer\">oszlop diagram<\/a> (vagy elfektetve s\u00e1v diagram) szinte b\u00e1rmikor haszn\u00e1lhat\u00f3. Id\u0151beli trendekre ink\u00e1bb m\u00e1r a vonaldiagram a megfelel\u0151. A harmadik legn\u00e9pszer\u0171bb diagramt\u00edpus a k\u00f6r, vagy m\u00e1s n\u00e9ven torta diagram, amely az egyes t\u00e9telek sz\u00e1zal\u00e9kos ar\u00e1ny\u00e1t mutatja meg.<!--more--><\/p>\n<p>Ebben a vide\u00f3ban a 2016-os Excellel k\u00e9sz\u00edtek diagramokat, m\u00edg itt a cikkben a 2007-es \u00e9s 2010-es Excelben mutatom be a diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9seit.<\/p>\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/T8j_0XUdd14\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p class=\"wp-block-paragraph\">N\u00e9zd meg a vide\u00f3t, verzi\u00f3t\u00f3l f\u00fcggetlen\u00fcl sokat tanulhatsz bel\u0151le.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Jel\u00f6ld ki a diagram k\u00e9sz\u00edt\u00e9shez az adatokat<\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-beszuras.png\"><img decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-beszuras.png\" alt=\"diagram-keszites-beszuras\" class=\"wp-image-3354\"\/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A diagram k\u00e9sz\u00edt\u00e9s sikeress\u00e9ge nagyr\u00e9szt azon m\u00falik, hogy j\u00f3l jel\u00f6l\u00f6d-e ki&nbsp;a sz\u00fcks\u00e9ges adatokat.&nbsp;A szab\u00e1ly nagyon egyszer\u0171: <strong>azokat a sz\u00f6vegeket \u00e9s adatokat jel\u00f6ld ki, amelyeket l\u00e1tni akarsz a diagramon<\/strong>. Azokat viszont ne, amelyeket nem!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mit jelent ez? P\u00e9ld\u00e1ul az \u00f6sszesen \u00e9rt\u00e9keket ritk\u00e1n tessz\u00fck egy diagramra az egyedi&nbsp;adatokkal. Tov\u00e1bb\u00e1 az adatok (sz\u00e1mok) mellett sz\u00fcks\u00e9ged lesz a feliratokra is.&nbsp;Hiszen ett\u0151l&nbsp;lesz \u00e9rthet\u0151 a diagram, ha r\u00e1 van \u00edrva,&nbsp;hogy mi mit jelent pontosan.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. V\u00e1laszd ki a megfelel\u0151 diagram t\u00edpust!<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Teh\u00e1t el\u0151sz\u00f6r jel\u00f6ld ki az \u00e1br\u00e1zolni k\u00edv\u00e1nt&nbsp;adatokat, \u00e9s a hozz\u00e1juk tartoz\u00f3 oszlop- \u00e9s<br>sorfeliratokat is. <strong>A Ctrl seg\u00edts\u00e9g\u00e9vel kijel\u00f6lhetsz nem szomsz\u00e9dos cell\u00e1kat, tartom\u00e1nyokat is<\/strong>, ha&nbsp;a kijel\u00f6lt ter\u00fcletek egy\u00fcttesen t\u00e9glalapot alkotnak.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"183\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-300x183.png\" alt=\"Elk\u00e9sz\u00fclt a diagram!\" class=\"wp-image-3350\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-300x183.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi-240x147.png 240w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/04\/diagram-keszites-ennyi.png 491w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Ezt k\u00f6vet\u0151en&nbsp;kattints a <strong>Besz\u00far\u00e1s men\u00fcre<\/strong>, majd a&nbsp;Diagramok csoportb\u00f3l&nbsp;<strong>v\u00e1laszd ki a megfelel\u0151 t\u00edpust.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">M\u00e1ris elk\u00e9sz\u00fclt a diagram!<\/p>\n\n\n\n<h6 class=\"wp-block-heading\">Mi\u00e9rt megy mag\u00e1t\u00f3l a diagram k\u00e9sz\u00edt\u00e9s?<\/h6>\n\n\n\n<p class=\"wp-block-paragraph\">Az Excel felismeri az adatokat, \u00e9s a legt\u00f6bb esetben els\u0151re j\u00f3l helyezi el \u0151ket a diagramon:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A adatsorok lesznek az&nbsp;oszlopok, \u00e9s a&nbsp;jelmagyar\u00e1zat megjelenik a jobb sz\u00e9len.<\/li><li>Az oszlopok elnevez\u00e9sei a&nbsp;diagram alj\u00e1n jelennek meg feliratk\u00e9nt.<\/li><li>A diagram bal oldal\u00e1n a tengelyen az Excel automatikusan&nbsp;l\u00e9trehoz egy sz\u00e1msk\u00e1l\u00e1t.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">3. Haszn\u00e1ld a be\u00e9p\u00edtett diagram sablonokat!<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A diagram l\u00e9trehoz\u00e1s\u00e1val egy\u00fctt megjelent a men\u00fcn a <strong>Diagrameszk\u00f6z\u00f6k f\u00fcl<\/strong>, ahol sz\u00e1mos hasznos ikont tal\u00e1lsz. <strong>Ezen bel\u00fcl is a legfontosabban a Tervez\u00e9s f\u00fcl\u00f6n vannak<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\"><img decoding=\"async\" width=\"490\" height=\"220\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\" alt=\"Diagram k\u00e9sz\u00edt\u00e9skor megjelenik a diagrameszk\u00f6z\u00f6k men\u00fc\" class=\"wp-image-2818\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png 490w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc-300x135.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc-240x108.png 240w\" sizes=\"(max-width: 490px) 100vw, 490px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">St\u00edlusok sz\u00e9les v\u00e1laszt\u00e9k\u00e1t tal\u00e1lod itt, csak kattints jobb oldalt a leny\u00edl\u00f3 h\u00e1romsz\u00f6gre.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszkozok-menu-word.png\"><img decoding=\"async\" width=\"653\" height=\"131\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszkozok-menu-word.png\" alt=\"diagrameszkozok-menu-word\" class=\"wp-image-2823\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszkozok-menu-word.png 653w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszkozok-menu-word-300x60.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszkozok-menu-word-240x48.png 240w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A sz\u00ednek mellett (balra) <strong>k\u00e9sz elrendez\u00e9seket&nbsp;is tal\u00e1lsz<\/strong>. Ezzel hat\u00e1rozhatod meg, hogy milyen inform\u00e1ci\u00f3k \u00e9s hol szerepeljenek a grafikonon. Itt is t\u00f6bb lehet\u0151s\u00e9g van, mint els\u0151re l\u00e1tszik, v\u00e1lassz olyat,&nbsp;ami legink\u00e1bb megfelel az&nbsp;elk\u00e9pzel\u00e9seidnek.&nbsp;P\u00e9ld\u00e1ul&nbsp;figyelj r\u00e1, hogy legyen c\u00edme diagramnak.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ink\u00e1bb t\u00f6bb inform\u00e1ci\u00f3 legyen legyen a kiv\u00e1lasztott sablonon, mivel a&nbsp;diagramr\u00f3l b\u00e1rmit k\u00f6nnyen t\u00f6r\u00f6lhetsz: ehhez jel\u00f6ld ki az adott r\u00e9szt, \u00e9s&nbsp;nyomd meg a Delete billenty\u0171t.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Adj c\u00edmet a diagramnak<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jel\u00f6ld ki a c\u00edmet (csak egyszer kattints r\u00e1), \u00e9s \u00edrd be az&nbsp;elnevez\u00e9st. Ne ijedj meg: \u00edr\u00e1skor m\u00e9g csak&nbsp;a szerkeszt\u0151l\u00e9cen l\u00e1tod. Az Enter megnyom\u00e1sa ut\u00e1n ker\u00fcl a hely\u00e9re a c\u00edm.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. M\u00f3dos\u00edtsd a diagramot kedved szerint<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A diagramon b\u00e1rmit m\u00f3dos\u00edthatsz, amit ki tudsz jel\u00f6lni. Nyomj egy jobbklikket az adott r\u00e9szen, \u00e9s m\u00e1ris megjelenik a form\u00e1z\u00f3 paletta. (Ha m\u00e9gsem, akkor haszn\u00e1ld a Kezd\u0151lap form\u00e1z\u00e1s ikonjait)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/03\/terv-diagram-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"363\" height=\"347\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/03\/terv-diagram-4.png\" alt=\"terv-diagram-4\" class=\"wp-image-3205\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/03\/terv-diagram-4.png 363w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/03\/terv-diagram-4-300x287.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2016\/03\/terv-diagram-4-240x229.png 240w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Feliratokn\u00e1l a bet\u0171t\u00edpust \u00e9s m\u00e9retet is m\u00f3dos\u00edthatod.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az oszlopok sz\u00edn\u00e9t a v\u00f6d\u00f6r ikonn\u00e1l, a ny\u00edlra kattintva v\u00e1ltoztathatod.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00dcgyelj arra, hogy a sz\u00ednek j\u00f3l megk\u00fcl\u00f6nb\u00f6ztethet\u0151ek legyenek.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">T\u00fal sok id\u0151t ne pazarolj a m\u00f3dos\u00edt\u00e1sokra: ink\u00e1bb a be\u00e9p\u00edtett sablonok k\u00f6z\u00fcl v\u00e1lassz.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">N\u00e9h\u00e1ny extra&nbsp;tudnival\u00f3 a diagramokr\u00f3l<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ha m\u00f3dos\u00edtod a t\u00e1bl\u00e1zat&nbsp;adatait (feliratok, sz\u00e1mok), azok egyb\u0151l&nbsp;friss\u00fclnek a diagramon is.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ak\u00e1r az eg\u00e9sz diagramot is tudod&nbsp;a Delete-tel t\u00f6r\u00f6lni.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A diagramot <a href=\"https:\/\/sosexcel.com\/exceltippek\/diagram-masolas-word-ppt\/\" target=\"_blank\" rel=\"noreferrer noopener\">b\u00e1rmikor \u00e1thelyezheted<\/a> Word jelent\u00e9sbe, PowerPoint&nbsp;prezent\u00e1ci\u00f3ba, s\u0151t ak\u00e1r e-mailbe is beillesztheted: egy egyszer\u0171&nbsp;Copy-Paste m\u0171velettel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Olvasd el ezt a&nbsp;cikket is a diagramokr\u00f3l:&nbsp;<a href=\"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/\" target=\"_blank\" rel=\"noreferrer noopener\">5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha maradt k\u00e9rd\u00e9sed a diagramokr\u00f3l, akkor \u00edrd meg a hozz\u00e1sz\u00f3l\u00e1sokn\u00e1l!<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"T4PwoDk01V\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/5-hatasos-tipp-az-adatok-prezentalasahoz\/\">5 hat\u00e1sos tipp adatelemz\u00e9shez \u00e9s prezent\u00e1l\u00e1shoz<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;5 hat\u00e1sos tipp adatelemz\u00e9shez \u00e9s prezent\u00e1l\u00e1shoz&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/5-hatasos-tipp-az-adatok-prezentalasahoz\/embed\/#?secret=OscI9wz3Ow#?secret=T4PwoDk01V\" data-secret=\"T4PwoDk01V\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"IGH0zrIGSu\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/meres-informacio-tarolas-adatelemzes\/\">Seg\u00edts\u00e9g, infod\u00f6mping! M\u00e9r\u00e9s, inform\u00e1ci\u00f3 t\u00e1rol\u00e1s \u00e9s adatelemz\u00e9s k\u00f6z\u00e9rthet\u0151en<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Seg\u00edts\u00e9g, infod\u00f6mping! M\u00e9r\u00e9s, inform\u00e1ci\u00f3 t\u00e1rol\u00e1s \u00e9s adatelemz\u00e9s k\u00f6z\u00e9rthet\u0151en&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/meres-informacio-tarolas-adatelemzes\/embed\/#?secret=5nt1EsSBTD#?secret=IGH0zrIGSu\" data-secret=\"IGH0zrIGSu\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, sokszor ink\u00e1bb az a k\u00e9rd\u00e9s,\u00a0hogy melyik diagram-t\u00edpus a legmegfelel\u0151bb a\u00a0szeml\u00e9ltet\u00e9shez. Az oszlop diagram (vagy elfektetve s\u00e1v diagram) szinte b\u00e1rmikor haszn\u00e1lhat\u00f3. Id\u0151beli trendekre ink\u00e1bb m\u00e1r a vonaldiagram a megfelel\u0151. A harmadik legn\u00e9pszer\u0171bb diagramt\u00edpus a k\u00f6r, vagy m\u00e1s n\u00e9ven torta diagram, amely az egyes t\u00e9telek sz\u00e1zal\u00e9kos ar\u00e1ny\u00e1t mutatja meg.<\/p>\n","protected":false},"author":1,"featured_media":2818,"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-3326","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-diagram"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/\" \/>\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=\"2016-04-11T17:55:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-05T00:47:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\" \/>\n\t<meta property=\"og:image:width\" content=\"490\" \/>\n\t<meta property=\"og:image:height\" content=\"220\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"4 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei\",\"datePublished\":\"2016-04-11T17:55:49+00:00\",\"dateModified\":\"2020-07-05T00:47:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/\"},\"wordCount\":887,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\",\"keywords\":[\"diagram\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/\",\"name\":\"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\",\"datePublished\":\"2016-04-11T17:55:49+00:00\",\"dateModified\":\"2020-07-05T00:47:02+00:00\",\"description\":\"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/09\\\/diagrameszk\u00f6z\u00f6k-men\u00fc.png\",\"width\":490,\"height\":220},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/a-profi-diagram-keszites-lepesei\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei\"}]},{\"@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":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/","og_locale":"hu_HU","og_type":"article","og_title":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.","og_url":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2016-04-11T17:55:49+00:00","article_modified_time":"2020-07-05T00:47:02+00:00","og_image":[{"width":490,"height":220,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"4 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei","datePublished":"2016-04-11T17:55:49+00:00","dateModified":"2020-07-05T00:47:02+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/"},"wordCount":887,"commentCount":2,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png","keywords":["diagram"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/","url":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/","name":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png","datePublished":"2016-04-11T17:55:49+00:00","dateModified":"2020-07-05T00:47:02+00:00","description":"A diagram k\u00e9sz\u00edt\u00e9s egy\u00e1ltal\u00e1n nem bonyolult dolog, a cikket elolvasva Te is k\u00f6nnyen megtanulhatod.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/diagrameszk\u00f6z\u00f6k-men\u00fc.png","width":490,"height":220},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/a-profi-diagram-keszites-lepesei\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"A profi diagram k\u00e9sz\u00edt\u00e9s l\u00e9p\u00e9sei"}]},{"@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\/3326","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=3326"}],"version-history":[{"count":26,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3326\/revisions"}],"predecessor-version":[{"id":8841,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/3326\/revisions\/8841"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/2818"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=3326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=3326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=3326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}