{"id":75045,"date":"2021-02-23T08:32:00","date_gmt":"2021-02-23T06:32:00","guid":{"rendered":"https:\/\/learnesy.com\/?p=75045"},"modified":"2022-04-01T11:00:48","modified_gmt":"2022-04-01T10:00:48","slug":"hur-man-gor-ringdiagram-i-excel-snyggt-i-presentationer","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/hur-man-gor-ringdiagram-i-excel-snyggt-i-presentationer\/","title":{"rendered":"Hur man g\u00f6r Ringdiagram i Excel, snyggt i presentationer!"},"content":{"rendered":"\r\n<p>Ringdiagram kan vara ett perfekt verktyg att visualisera resultat eller andel av uppn\u00e5tt m\u00e5l. Diagrammen kan anses vara lite komplicerat att s\u00e4tta ihop om man inte gjort det f\u00f6rut, dock \u00e4r det enklare \u00e4n man tror och har uppskattats de g\u00e5nger jag implementerat dem i lednings presentationer.<\/p>\r\n<p><strong>Ladda ned exempelfil s\u00e5 ni kan testa och se hur alla varianter i detta inl\u00e4gg fungerar:<br \/><\/strong><a href=\"\/wp-content\/uploads\/2021\/02\/Doughnut-Charts-Learnesy.xlsx\">Doughnut Charts Learnesy &#8211; <\/a><a class=\"wp-block-file__button\" href=\"\/wp-content\/uploads\/2021\/02\/Doughnut-Charts-Learnesy.xlsx\" download=\"\">Ladda ner.<\/a><\/p>\r\n\r\n\r\n\r\n<p>\r\n\r\n<\/p>\r\n\r\n\r\n\r\n<span id=\"heading-vad-ar-ett-ringdiagram\"><h3 class=\"wp-block-heading\">Vad \u00e4r ett ringdiagram?<\/h3><\/span>\r\n\r\n\r\n\r\n<p>Ett ringdiagram \u00e4r ett diagram som konstruerats s\u00e5 att 100% av n\u00e5gonting motsvarar hela ringen. Om man infogar resultatet som uppn\u00e5tts, l\u00e5t oss s\u00e4ga 75%, s\u00e5 ser man v\u00e4ldigt tydligt hur man ligger mot plan\u2026det blir inte tydligare \u00e4n s\u00e5.<\/p>\r\n\r\n\r\n\r\n<p>Ringdiagram kan g\u00f6ras p\u00e5 ett avancerat s\u00e4tt med vissa visuella f\u00f6rdelar, samt p\u00e5 ett enkelt s\u00e4tt d\u00e4r man fortfarande f\u00e5r det mest essentiella.<\/p>\r\n\r\n\r\n\r\n<p>F\u00f6rdelarna \u00e4r:<\/p>\r\n<ul>\r\n<li>Ger en tydligt bild av uppn\u00e5tt resultat<\/li>\r\n<li>Visuellt snyggt i en presentation<\/li>\r\n<li>Brukar leda till bra m\u00f6tes-diskussioner<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n\r\n\r\n<p>Nackdelarna \u00e4r:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Om man vill g\u00f6ra det avancerat tar det lite tid<\/li>\r\n<li>Tar plats i en presentation<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<span id=\"heading-nar-anvander-jag-ringdiagram\"><h3 class=\"wp-block-heading\">N\u00e4r anv\u00e4nder jag ringdiagram?<\/h3><\/span>\r\n\r\n\r\n\r\n<p>Jag anser ringdiagram vara l\u00e4mpliga f\u00f6r f\u00f6ljande:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li>Oms\u00e4ttnings-presentationer<\/li>\r\n<li>L\u00f6nsamhetsm\u00e5tt<\/li>\r\n<li>Uppf\u00f6ljning strategiska initiativ<\/li>\r\n<li>Projektuppf\u00f6ljning<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<span id=\"heading-hur-satter-man-ihop-ett-enkelt-ringdiagram\"><h3 class=\"wp-block-heading\">Hur s\u00e4tter man ihop ett enkelt ringdiagram?<\/h3><\/span>\r\n\r\n\r\n\r\n<p>Anv\u00e4nd f\u00f6ljande steg:<\/p>\r\n\r\n\r\n\r\n<ol class=\"wp-block-list\" type=\"1\">\r\n<li>G\u00e5 in p\u00e5 \u201dInfoga\u201d\u2026cirkeldiagram och sen v\u00e4ljer ringdiagram.<\/li>\r\n<li>Notera utfallet samt deltat mellan budget och utfall.<\/li>\r\n<li>Avklarade andelen l\u00e4gger man in manuellt genom att skapa en textruta<\/li>\r\n<li>Skriv sedan tex =E2 samt ha andelen ber\u00e4knad i just E2.<br \/><img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"739\" class=\"wp-image-75046\" src=\"\/wp-content\/uploads\/2021\/01\/13.1.png\" alt=\"\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.1.png 824w, \/wp-content\/uploads\/2021\/01\/13.1-300x269.png 300w, \/wp-content\/uploads\/2021\/01\/13.1-768x689.png 768w, \/wp-content\/uploads\/2021\/01\/13.1-335x300.png 335w, \/wp-content\/uploads\/2021\/01\/13.1-600x538.png 600w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><\/li>\r\n<li>Nedan ser ni ett par ringdiagram som tar lite l\u00e4ngre tid att s\u00e4tta ihop. F\u00f6r den f\u00f6rsta s\u00e5 beh\u00f6ver man arbeta lite med formatering av fyllningen och i det andra fallet s\u00e5 beh\u00f6ver man l\u00e4gga till ytterligare en dataserie f\u00f6r att erh\u00e5lla sektionerna.<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\r\n<figure><img loading=\"lazy\" decoding=\"async\" width=\"452\" height=\"331\" class=\"wp-image-75051\" src=\"\/wp-content\/uploads\/2021\/01\/13.2.png\" alt=\"\" data-id=\"75051\" data-full-url=\"\/wp-content\/uploads\/2021\/01\/13.2.png\" data-link=\"https:\/\/learnesy.com\/sv\/?attachment_id=75051\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.2.png 452w, \/wp-content\/uploads\/2021\/01\/13.2-300x220.png 300w, \/wp-content\/uploads\/2021\/01\/13.2-400x293.png 400w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/figure>\r\n<figure><img loading=\"lazy\" decoding=\"async\" width=\"393\" height=\"354\" class=\"wp-image-75056\" src=\"\/wp-content\/uploads\/2021\/01\/13.3.png\" alt=\"\" data-id=\"75056\" data-full-url=\"\/wp-content\/uploads\/2021\/01\/13.3.png\" data-link=\"https:\/\/learnesy.com\/sv\/?attachment_id=75056\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.3.png 393w, \/wp-content\/uploads\/2021\/01\/13.3-300x270.png 300w, \/wp-content\/uploads\/2021\/01\/13.3-333x300.png 333w\" sizes=\"auto, (max-width: 393px) 100vw, 393px\" \/><\/figure>\r\n<\/figure>\r\n\r\n\r\n\r\n<span id=\"heading-varianter\"><h3 class=\"wp-block-heading\">Varianter<\/h3><\/span>\r\n\r\n\r\n\r\n<p>Om man orkar kan man experimentera med diagrammen s\u00e5 kan man erh\u00e5lla b\u00e4sta m\u00f6jliga slutprodukt. Om nu resultatet \u00e4r \u00f6ver 100%&#8230;hur ser det d\u00e5 ut?? Jag testade ett tag och laborerade fram nedan variant d\u00e4r diagrammet delats upp i 4 delar; utfall (om utfall \u00e4r mindre \u00e4n budget), delta (om utfall \u00e4r mindre \u00e4n budget), budget, delta (om utfall \u00e4r st\u00f6rre \u00e4n budget) samt \u00f6vrig del f\u00f6r att ringen ska bli 360% d\u00e4r budget \u00e4r 180%.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-gallery columns-2 is-cropped wp-block-gallery-3 is-layout-flex wp-block-gallery-is-layout-flex\">\r\n<figure><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"339\" class=\"wp-image-75061\" src=\"\/wp-content\/uploads\/2021\/01\/13.4.png\" alt=\"\" data-id=\"75061\" data-full-url=\"\/wp-content\/uploads\/2021\/01\/13.4.png\" data-link=\"https:\/\/learnesy.com\/sv\/?attachment_id=75061\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.4.png 454w, \/wp-content\/uploads\/2021\/01\/13.4-300x224.png 300w, \/wp-content\/uploads\/2021\/01\/13.4-400x300.png 400w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/figure>\r\n<figure><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"341\" class=\"wp-image-75066\" src=\"\/wp-content\/uploads\/2021\/01\/13.5.png\" alt=\"\" data-id=\"75066\" data-full-url=\"\/wp-content\/uploads\/2021\/01\/13.5.png\" data-link=\"https:\/\/learnesy.com\/sv\/?attachment_id=75066\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.5.png 454w, \/wp-content\/uploads\/2021\/01\/13.5-300x225.png 300w, \/wp-content\/uploads\/2021\/01\/13.5-400x300.png 400w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/figure>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Hyfsat snyggt eller hur? Budgeten \u00e4r h\u00e4r 500 tkr och i f\u00f6rsta varianten har man 100 tkr i negativt delta och i andra fallet har man n\u00e5tt \u00f6ver budgeten med 75 tkr. Att l\u00e4ra sig ringdiagram tar lite tid men n\u00e4r man bem\u00e4strar dem s\u00e5 kan det bli riktigt presentabelt i en PPT-presentation\u2026<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"945\" height=\"539\" class=\"wp-image-75071\" src=\"\/wp-content\/uploads\/2021\/01\/13.6.png\" alt=\"\" srcset=\"\/wp-content\/uploads\/2021\/01\/13.6.png 945w, \/wp-content\/uploads\/2021\/01\/13.6-300x171.png 300w, \/wp-content\/uploads\/2021\/01\/13.6-768x438.png 768w, \/wp-content\/uploads\/2021\/01\/13.6-400x228.png 400w, \/wp-content\/uploads\/2021\/01\/13.6-600x342.png 600w\" sizes=\"auto, (max-width: 945px) 100vw, 945px\" \/><\/figure>\r\n\r\n\r\n\r\n<div>\u00a0<\/div>\r\n<div>Vill du l\u00e4ra dig mer om datavisualisering? Vi har en kurs f\u00f6r dig!<\/div>\r\n<div><a href=\"https:\/\/learnesy.com\/sv\/courses\/datavisualisering-i-excel\/\">Datavisualisering i Excel<\/a><\/div>\r\n<div>&#8211; G\u00f6r det enkelt att se och f\u00f6rst\u00e5 data genom grafer och diagram i Excel.<\/div>\r\n<div>\u00a0<\/div>\r\n\r\n\r\n\r\n\r\n\r\n<p>V\u00e4lkomna att connecta med mig p\u00e5 <a href=\"https:\/\/www.linkedin.com\/in\/carlstiller\/\">Linkedin.<\/a><\/p>\r\n\r\n\r\n\r\n<p><em>Carl Stiller i samarbete med Learnesy<\/em><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Ringdiagram kan vara ett perfekt verktyg att visualisera resultat eller andel av uppn\u00e5tt m\u00e5l. Diagrammen kan anses vara lite komplicerat att s\u00e4tta ihop om man inte gjort det f\u00f6rut, dock \u00e4r det enklare \u00e4n man [&hellip;]<\/p>\n","protected":false},"author":2342,"featured_media":142872,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[151],"tags":[197,218,247,65,353],"class_list":["post-75045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gastblogg","tag-datavisualisering","tag-excel-online","tag-excelfunktioner","tag-excelkurs","tag-ringdiagram"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/75045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/2342"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=75045"}],"version-history":[{"count":22,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/75045\/revisions"}],"predecessor-version":[{"id":142877,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/75045\/revisions\/142877"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/142872"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=75045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=75045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=75045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}