{"id":1348,"date":"2014-07-29T20:27:10","date_gmt":"2014-07-29T18:27:10","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=1348"},"modified":"2020-07-05T02:50:47","modified_gmt":"2020-07-05T00:50:47","slug":"5-dolog-amit-tudnod-kell-a-diagram-keszitesrol","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/","title":{"rendered":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l"},"content":{"rendered":"<p>L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagramokat szeretn\u00e9l k\u00e9sz\u00edteni? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st!<\/p>\n<h3>1. Mi\u00e9rt kellenek a diagramok?<\/h3>\n<p>A legt\u00f6bb ember <strong>vizu\u00e1lis t\u00edpus<\/strong>, ez\u00e9rt k\u00f6nnyebben tud \u00e9rtelmezni egy \u00e1br\u00e1t, mint egy sz\u00e1msort vagy t\u00e1bl\u00e1zatot. Ez\u00e9rt fontos, hogy az <a title=\"5 hat\u00e1sos tipp az adatok prezent\u00e1l\u00e1s\u00e1hoz\" href=\"https:\/\/sosexcel.com\/exceltippek\/5-hatasos-tipp-az-adatok-prezentalasahoz\/\" target=\"_blank\" rel=\"noopener noreferrer\">adatok prezent\u00e1l\u00e1sakor<\/a> diagramokat is haszn\u00e1lj.<!--more--><\/p>\n<p>Ha teh\u00e1t m\u00e1r megvannak az adataid, akkor tedd \u00e9l\u0151v\u00e9 egy grafikon seg\u00edts\u00e9g\u00e9vel: jel\u00f6ld ki a t\u00e1bl\u00e1zatodat, \u00e9s az Excel\u00a0Besz\u00far\u00e1s lapj\u00e1n v\u00e1laszd ki a Diagramok csoportban a megfelel\u0151 t\u00edpust.<\/p>\n<h3>2. Mindig a megfelel\u0151 diagram-t\u00edpust v\u00e1laszd<\/h3>\n<p>A diagram sikere az adatokon k\u00edv\u00fcl azon m\u00falik, hogy a j\u00f3 t\u00edpust v\u00e1lasztod-e a megjelen\u00edt\u00e9shez. Legt\u00f6bbsz\u00f6r\u00a0<a title=\"Mi a k\u00fcl\u00f6nbs\u00e9g a csoportos\u00edtott \u00e9s a halmozott oszlop diagram k\u00f6z\u00f6tt?\" href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-kulonbseg-a-csoportositott-es-a-halmozott-oszlop-diagram-kozott\/\" target=\"_blank\" rel=\"noopener noreferrer\">haszn\u00e1lhatod az <strong>oszlopdiagramot<\/strong><\/a>, de ezen bel\u00fcl is figyelj a megfelel\u0151 fajta kiv\u00e1laszt\u00e1s\u00e1ra.<\/p>\n<p>Szerencs\u00e9re m\u00e1r a stiliz\u00e1lt ikonok is seg\u00edtenek az \u00e1ttekint\u00e9sben, de ak\u00e1r \u00fajra is kezdheted a diagram-k\u00e9sz\u00edt\u00e9st, vagy k\u00e9s\u0151bb is k\u00f6nnyen m\u00f3dos\u00edthatsz, ha nem siker\u00fclt els\u0151re megtal\u00e1lnod azt a form\u00e1t, amely a legvil\u00e1gosabban \u00e1br\u00e1zolja az \u00f6sszef\u00fcgg\u00e9seket.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png\"><img decoding=\"async\" class=\"size-full wp-image-1352 alignleft\" title=\"\u00d6sszehasonl\u00edt\u00f3 vonaldiagram\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png\" alt=\"Vonaldiagram\" width=\"228\" height=\"152\" \/><\/a><\/p>\n<p>Ha id\u0151belis\u00e9get vagy trendeket kell szeml\u00e9ltetned,\u00a0akkor a <strong>vonaldiagram<\/strong> a leghat\u00e1sosabb v\u00e1ltozat.<\/p>\n<p>P\u00e9ld\u00e1ul ide\u00e1lis napok, h\u00f3napok,\u00a0negyed\u00e9vek vagy p\u00e9nz\u00fcgyi \u00e9vek \u00f6sszehasonl\u00edt\u00e1s\u00e1n\u00e1l, terv-t\u00e9ny\u00a0kontrolln\u00e1l, vagy r\u00e9szv\u00e9ny\u00e1rfolyamok alakul\u00e1s\u00e1nak \u00e1br\u00e1zol\u00e1sakor.<\/p>\n<p>Itt is figyelj oda, hogy az adatokat egym\u00e1shoz viszony\u00edtod, vagy kumul\u00e1ltan akarod \u00e1br\u00e1zolni.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/tortadiagram.png\"><img decoding=\"async\" class=\"wp-image-844 alignleft\" style=\"border: 1px solid grey;\" title=\"K\u00f6r vagy tortadiagram\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/tortadiagram.png\" alt=\"Tortadiagramn\u00e1l a cikkek nagys\u00e1ga mutatja az \u00f6sszet\u00e9telt\" width=\"228\" height=\"136\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/tortadiagram.png 481w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/tortadiagram-300x180.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/01\/tortadiagram-240x144.png 240w\" sizes=\"(max-width: 228px) 100vw, 228px\" \/><\/a><\/p>\n<p>A harmadik legelterjedtebb diagramt\u00edpus a <strong>k\u00f6r- vagy tortadiagram<\/strong>, amely az egyes\u00a0t\u00e9telek ar\u00e1ny\u00e1t a teljes\u00a0\u00f6sszeghez viszony\u00edtva\u00a0mutatja.<\/p>\n<p>Az egyes\u00a0kateg\u00f3ri\u00e1k azt mutatj\u00e1k, hogy a teljes tort\u00e1nak mekkora r\u00e9sz\u00e9t, szelet\u00e9t k\u00e9pezik.<\/p>\n<p>Pr\u00f3b\u00e1lj meg egyszer\u0171bb k\u00f6rdiagramot v\u00e1lasztani, mert ez a 3D verzi\u00f3 torz\u00edtja az adatokat!<\/p>\n<p>N\u00e9zd meg a diagramk\u00e9sz\u00edt\u00e9sr\u0151l sz\u00f3l\u00f3 vide\u00f3mat:<\/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<h3 class=\"wp-block-heading\">3. Haszn\u00e1lj megfelel\u0151 feliratokat<\/h3>\n\n\n\n<p>Az \u00e1br\u00e1d akkor lesz val\u00f3ban \u00e9rthet\u0151, ha tartalmazza a megfelel\u0151 inform\u00e1ci\u00f3kat.<\/p>\n\n\n\n<p><strong>Mindenk\u00e9ppen adj c\u00edmet a diagramnak!<\/strong> Ez al\u00f3l csak az mentes\u00edt, ha sablon prezent\u00e1ci\u00f3ba (Word, Ppt) m\u00e1solod \u00e1t a diagramot, ahol k\u00fcl\u00f6n helye van a c\u00edmnek.<\/p>\n\n\n\n<p>A <strong>kateg\u00f3ri\u00e1kat<\/strong> is jel\u00f6ld elk\u00fcl\u00f6n\u00fcl\u0151 sz\u00ednekkel, \u00e9s mindig t\u00fcntesd fel az elnevez\u00e9seket. Kiv\u00e9tel, ha \u00f6sszesen egy adatot szeml\u00e9ltetsz, \u00e9s azt m\u00e1r a c\u00edmbe belefoglaltad. (p\u00e9ld\u00e1ul Minim\u00e1l b\u00e9r alakul\u00e1sa). Az elnevez\u00e9s szerepelhet k\u00fcl\u00f6n jelmagyar\u00e1zatk\u00e9nt, de az \u00e1br\u00e1n is elhelyezheted.<\/p>\n\n\n\n<p>A <strong>tengelyek<\/strong> sz\u00e1moz\u00e1sa, feliratoz\u00e1sa \u00e1ltal\u00e1ban automatikusan is j\u00f3l t\u00f6rt\u00e9nik, de ezt is ellen\u0151rizd, \u00e9s ha sz\u00fcks\u00e9ges, jav\u00edtsd. Ha sz\u00fcks\u00e9ges, haszn\u00e1lj tengelyc\u00edmeket.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Ker\u00fcld a felesleges adatokat, inform\u00e1ci\u00f3kat<\/h3>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"998\" height=\"302\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat.jpg\" alt=\"diagram-felirat\" class=\"wp-image-1377\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat.jpg 998w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat-300x90.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat-660x199.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/diagram-felirat-240x72.jpg 240w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Van, hogy a t\u00e1bl\u00e1zatban 2 oszlopban szerepel a megnevez\u00e9s, ami a diagramon rosszul n\u00e9z ki. Ilyenkor fokozottan \u00fcgyelj a kijel\u00f6l\u00e9sre, vagy ak\u00e1r fogalmazd \u00e1t az elnevez\u00e9seket.<\/p>\n\n\n\n<p>Tengelyfeliratokat csak akkor haszn\u00e1lj, ha val\u00f3ban t\u00f6bblet inform\u00e1ci\u00f3t jelentenek. P\u00e9ld\u00e1ul a jan, febr, m\u00e1rc felsorol\u00e1s mellett nem kell ki\u00edrnod, hogy h\u00f3napok, de hasznos lehet, ha azt jelzed, hogy ez a fizet\u00e9s id\u0151pontja.<\/p>\n\n\n\n<p>Ha felesleges adatsor vagy felirat ker\u00fclt a diagramra, akkor egyszer\u0171en jel\u00f6ld ki, \u00e9s a <strong>Delete<\/strong> gomb megnyom\u00e1s\u00e1val t\u00e1vol\u00edtsd el.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. Form\u00e1zd eszt\u00e9tikusan a diagramot<\/h3>\n\n\n\n<p>A Diagrameszk\u00f6z\u00f6k panel is lehet\u0151s\u00e9get ad arra, hogy az el\u0151regy\u00e1rtott sz\u00edn- \u00e9s elrendez\u00e9s mint\u00e1k k\u00f6z\u00fcl v\u00e1lassz, \u00e9s megtal\u00e1ld a legkifejez\u0151bb m\u00f3dot. De ak\u00e1r saj\u00e1t sablonokat is l\u00e9trehozhatsz.<\/p>\n\n\n\n<p>Ha teheted, \u00e9rdemes a legfontosabb n\u00f6vekv\u0151 vagy cs\u00f6kken\u0151 <a href=\"https:\/\/sosexcel.com\/exceltippek\/hiba-sorba-rendezesnel-oszlopot-jelolsz-ki\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>sorrendbe rendezni<\/strong><\/a> az adatokat.<\/p>\n\n\n\n<p>Mint a norm\u00e1l form\u00e1z\u00e1sn\u00e1l, itt is \u00e9rdemes figyelned arra, hogy <strong>egys\u00e9ges \u00e9s eszt\u00e9tikus<\/strong> m\u00f3don k\u00e9sz\u00edtsd el az \u00e1br\u00e1t.<\/p>\n\n\n\n<p>Ha nagyobb t\u00f6meg el\u0151tt fogsz prezent\u00e1lni, akkor figyelj r\u00e1, hogy messzir\u0151l \u00e9s \u00e9rtelmezhet\u0151 legyen az \u00e1bra: haszn\u00e1lj nagyobb feliratokat \u00e9s j\u00f3l megk\u00fcl\u00f6nb\u00f6ztethet\u0151 sz\u00edneket.<\/p>\n\n\n\n<p><strong>K\u00edv\u00e1ncsi vagy, hogyan&nbsp;lehet gyorsan \u00f6sszeszedni azokat az adatokat, amib\u0151l ut\u00e1na diagramot k\u00e9sz\u00edthetsz? <a href=\"http:\/\/exceltitok.hu\/adatok-hatekony-menedzselese\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gyere el az Adatelemz\u00e9s workshopra!<\/a><\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Siker\u00fclt a tippeket \u00e1t\u00fcltetned a gyakorlatba?\nVan tov\u00e1bbi k\u00e9rd\u00e9sed a diagramokr\u00f3l?\nSaj\u00e1t tipped, amit megosztan\u00e1l?\n<strong>\u00cdrd meg a hozz\u00e1sz\u00f3l\u00e1sokn\u00e1l!<\/strong><\/pre>\n\n\n\n<p><strong><a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tov\u00e1bbi hasznos tippek\u00e9rt rendeld meg a 111 Hasznos Excel Tipp kiadv\u00e1nyt<\/a>&nbsp;vagy jelentkezz&nbsp;<a href=\"http:\/\/exceltitok.hu\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel mag\u00e1n\u00f3r\u00e1ra!<\/a><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"h3PGJJBMe0\"><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=SY0ctwLmPq#?secret=h3PGJJBMe0\" data-secret=\"h3PGJJBMe0\" 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=\"kflnE9Ve8n\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/valtozik-a-vilag\/\">V\u00e1ltozik a vil\u00e1g, de merre?<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;V\u00e1ltozik a vil\u00e1g, de merre?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/valtozik-a-vilag\/embed\/#?secret=0BbVjswIVu#?secret=kflnE9Ve8n\" data-secret=\"kflnE9Ve8n\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagramokat szeretn\u00e9l k\u00e9sz\u00edteni? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st! 1. Mi\u00e9rt kellenek a diagramok? A legt\u00f6bb ember vizu\u00e1lis t\u00edpus, ez\u00e9rt k\u00f6nnyebben tud \u00e9rtelmezni egy \u00e1br\u00e1t, mint egy sz\u00e1msort vagy t\u00e1bl\u00e1zatot. Ez\u00e9rt fontos, hogy az adatok prezent\u00e1l\u00e1sakor diagramokat is haszn\u00e1lj.<\/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-1348","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.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!\" \/>\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\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/\" \/>\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=\"2014-07-29T18:27:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-05T00:50:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.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\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l\",\"datePublished\":\"2014-07-29T18:27:10+00:00\",\"dateModified\":\"2020-07-05T00:50:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/\"},\"wordCount\":820,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/vonaldiagram.png\",\"keywords\":[\"diagram\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/\",\"name\":\"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/vonaldiagram.png\",\"datePublished\":\"2014-07-29T18:27:10+00:00\",\"dateModified\":\"2020-07-05T00:50:47+00:00\",\"description\":\"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/vonaldiagram.png\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/vonaldiagram.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l\"}]},{\"@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":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!","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\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/","og_locale":"hu_HU","og_type":"article","og_title":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!","og_url":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2014-07-29T18:27:10+00:00","article_modified_time":"2020-07-05T00:50:47+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png","type":"","width":"","height":""}],"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\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l","datePublished":"2014-07-29T18:27:10+00:00","dateModified":"2020-07-05T00:50:47+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/"},"wordCount":820,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png","keywords":["diagram"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/","url":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/","name":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png","datePublished":"2014-07-29T18:27:10+00:00","dateModified":"2020-07-05T00:50:47+00:00","description":"L\u00e1tv\u00e1nyos \u00e9s k\u00f6nnyen \u00e9rtelmezhet\u0151 diagram kell egy prezent\u00e1ci\u00f3hoz? Tartsd be a k\u00f6vetkez\u0151 5 l\u00e9p\u00e9st, \u00e9s saj\u00e1t\u00edtsd el a diagram-k\u00e9sz\u00edt\u00e9s fort\u00e9lyait!","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/vonaldiagram.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/5-dolog-amit-tudnod-kell-a-diagram-keszitesrol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"5 dolog, amit tudnod kell a diagram-k\u00e9sz\u00edt\u00e9sr\u0151l"}]},{"@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\/1348","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=1348"}],"version-history":[{"count":40,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1348\/revisions"}],"predecessor-version":[{"id":8843,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1348\/revisions\/8843"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}