{"id":215066,"date":"2025-07-10T10:10:28","date_gmt":"2025-07-10T09:10:28","guid":{"rendered":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/?p=215066"},"modified":"2025-07-31T18:36:34","modified_gmt":"2025-07-31T17:36:34","slug":"drag-drop-org-chart-builder-visio-excel","status":"publish","type":"post","link":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/drag-drop-org-chart-builder-visio-excel\/","title":{"rendered":"Een organigram met slepen en neerzetten maken met Visio 2024 en Excel 2021"},"content":{"rendered":"<p><span style=\"font-weight: 400\">Organogrammen zijn essentieel voor het begrijpen van teamstructuren, het beheren van personeel en het communiceren van interne hi\u00ebrarchie\u00ebn. Maar het handmatig maken van organigrammen kan tijdrovend zijn, vooral als rollen vaak veranderen. Dat is waar de kracht van automatisering en interactie in Microsoft Visio 2024 in combinatie met Excel 2021 kan helpen.<\/span><\/p>\n<p>In deze handleiding begeleiden we u bij het bouwen van een organigrambouwer die met slepen en neerzetten gestructureerde personeelsgegevens uit Excel haalt en gebruikers de hi\u00ebrarchie visueel laat manipuleren in<a href=\"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/product\/microsoft-office-2021-professional-plus-microsoft-visio-2024-professional-lizenz-fuer-3-pc\/\"> MS Office 2021 Pro Plus + MS Visio 2024 Pro<\/a>. Of u nu in HR, operations of IT werkt, deze workflow zal u helpen om organigrammen sneller en intu\u00eftiever te beheren.<\/p>\n<h2><span style=\"font-size: 24pt\"><b>Waarom Visio en Excel samen gebruiken?<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Microsoft Excel is uitstekend voor het opslaan van gestructureerde werknemersgegevens. Microsoft Visio, aan de andere kant, biedt een visuele werkruimte waar die gegevens direct verteerbaar worden. In combinatie met elkaar:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Excel fungeert als de <\/span><b>backend<\/b><span style=\"font-weight: 400\"> (gegevensbron)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Visio fungeert als de <\/span><b>frontend<\/b><span style=\"font-weight: 400\"> (visuele interface)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Wijzigingen in Visio kunnen worden gespiegeld in Excel (met macro's of Power Query)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Bewerken met slepen en neerzetten in Visio vereenvoudigt hi\u00ebrarchie-updates<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Kenmerken van een Drag-and-Drop Org Chart Builder<\/b><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gegevens van werknemers importeren vanuit Excel<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Automatisch hi\u00ebrarchie genereren in Visio<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gebruik aangepaste vormen, foto's en kleurcodes<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Herschikken met slepen en neerzetten binnen de hi\u00ebrarchie inschakelen<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Bijgewerkte structuur exporteren of terug synchroniseren naar Excel<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Stap 1: Bereid uw Excel organigramgegevens voor<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Begin met een schone, gestructureerde spreadsheet die de rollen, ID's en rapportagestructuur van werknemers definieert.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Voorbeeldformaat:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Werknemer-ID<\/b><\/td>\n<td><b>Naam<\/b><\/td>\n<td><b>Titel<\/b><\/td>\n<td><b>Manager ID<\/b><\/td>\n<td><b>Afdeling<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">E001<\/span><\/td>\n<td><span style=\"font-weight: 400\">Alice Chen<\/span><\/td>\n<td><span style=\"font-weight: 400\">CEO<\/span><\/td>\n<td><\/td>\n<td><span style=\"font-weight: 400\">Uitvoerend team<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">E002<\/span><\/td>\n<td><span style=\"font-weight: 400\">Brian Lee<\/span><\/td>\n<td><span style=\"font-weight: 400\">CTO<\/span><\/td>\n<td><span style=\"font-weight: 400\">E001<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tech<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">E003<\/span><\/td>\n<td><span style=\"font-weight: 400\">Carol Smith<\/span><\/td>\n<td><span style=\"font-weight: 400\">CFO<\/span><\/td>\n<td><span style=\"font-weight: 400\">E001<\/span><\/td>\n<td><span style=\"font-weight: 400\">Financi\u00ebn<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">E004<\/span><\/td>\n<td><span style=\"font-weight: 400\">David Rao<\/span><\/td>\n<td><span style=\"font-weight: 400\">Engineering-leiderschap<\/span><\/td>\n<td><span style=\"font-weight: 400\">E002<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tech<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">E005<\/span><\/td>\n<td><span style=\"font-weight: 400\">Eve Grant<\/span><\/td>\n<td><span style=\"font-weight: 400\">Ontwikkelaar<\/span><\/td>\n<td><span style=\"font-weight: 400\">E004<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tech<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>Tips:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Zorg ervoor dat de Manager-ID overeenkomt met een andere Werknemer-ID<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Geen cirkelvormige verwijzingen<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Opslaan als <\/span><span style=\"font-weight: 400\">.xlsx<\/span><span style=\"font-weight: 400\"> of <\/span><span style=\"font-weight: 400\">.csv<\/span><span style=\"font-weight: 400\"> voor invoer<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Stap 2: Visio 2024 starten en de juiste sjabloon kiezen<\/b><\/span><\/h2>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Open <\/span><b>Visio 2024 Pro<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Zoek en selecteer de <\/span><b>Organogram<\/b><span style=\"font-weight: 400\"> sjabloon<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Kies <\/span><b>\"Informatie die ik invoer met behulp van een wizard\"<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">In de wizard:<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Selecteer <\/span><b>Excel-bestand<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Blader door uw voorbereide Excel-blad en open het<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Breng de velden dienovereenkomstig in kaart:<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Naam \u2192 Naam<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Titel \u2192 Titel<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Manager ID \u2192 Rapporteert aan<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Werknemer-ID \u2192 Uniek identificatienummer<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Visio genereert nu automatisch de hi\u00ebrarchie op basis van de relaties in uw Excel-bestand.<\/span><\/p>\n<h2><span style=\"font-size: 24pt\"><b>Stap 3: Het uiterlijk van het organigram aanpassen<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Zodra de structuur is gegenereerd, gebruikt u de opmaaktools van Visio om de bruikbaarheid te verbeteren:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><b>Vormen:<\/b><span style=\"font-weight: 400\"> Gebruik rechthoekige of badge-vormen met afgeronde hoeken<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Foto's:<\/b><span style=\"font-weight: 400\"> Voeg de headshots van werknemers toe (indien beschikbaar)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Kleuren:<\/b><span style=\"font-weight: 400\"> Maak onderscheid tussen afdelingen met behulp van kleurgecodeerde randen<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Tekstvelden:<\/b><span style=\"font-weight: 400\"> Titel, naam en afdeling weergeven met behulp van Data Graphics<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Afbeeldingen toevoegen:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Klik met de rechtermuisknop op een vorm<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Kies <\/span><b>Foto vervangen<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Selecteer van uw systeem of gedeelde locatie<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Voorwaardelijke kleuropmaak toepassen:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ga naar <\/span><b>Gegevens &gt; Gegevensgrafieken &gt; Nieuwe gegevensgrafiek maken<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Regels toevoegen (bijv. Afdeling = \"Financi\u00ebn\" \u2192 Geel vullen)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ol>\n<h2><span style=\"font-size: 24pt\"><b>Stap 4: De functionaliteit voor slepen en neerzetten inschakelen<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Visio maakt interactief herschikken van werknemers mogelijk:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Klik en sleep een vorm onder een andere manager<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Laat vallen om een nieuwe rapportrelatie toe te wijzen<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Visio zal de connectors dienovereenkomstig hertekenen<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Gegevensintegriteit behouden:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ga naar <\/span><b>Tabblad Organogram &gt; Opties<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Controleer <\/span><b>\"Gelinkte gegevens bijwerken wanneer diagram wordt bijgewerkt\"<\/b><span style=\"font-weight: 400\"> (indien beschikbaar)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Door een werknemer te slepen wordt zijn manager-ID op de achtergrond bijgewerkt<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Opmerking: Om deze wijzigingen terug te schrijven naar Excel, hebt u een macro of exportmethode nodig (zie Stap 6).<\/span><\/p>\n<h2><span style=\"font-size: 24pt\"><b>Stap 5: Swimlanes op afdelingsniveau toevoegen (optioneel)<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Voor de duidelijkheid in grote organigrammen:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Plaats <\/span><b>Zwembanen<\/b><span style=\"font-weight: 400\"> van de <\/span><b>Functionele stroomschema's Vormen<\/b><span style=\"font-weight: 400\"> ruit<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Label elk zwemgedeelte per afdeling<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Sleep vormen naar hun respectievelijke zwemlanes<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Formaat van rijstroken en containers aanpassen aan uw lay-out<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Dit helpt om technische, financi\u00eble en administratieve teams visueel te verdelen terwijl de rapportagestructuur intact blijft.<\/span><\/p>\n<h2><span style=\"font-size: 24pt\"><b>Stap 6: Exporteer of synchroniseer terug naar Excel<\/b><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Helaas biedt Visio geen native omgekeerde synchronisatie met Excel, maar u kunt wel gegevens exporteren:<\/span><\/p>\n<h3><span style=\"font-size: 18pt\"><b>Optie A: Kopi\u00ebren vanuit Shape Data<\/b><\/span><\/h3>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Selecteer alle vormen (Ctrl + A)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ga naar <\/span><b>Overzicht &gt; Vormrapporten<\/b><b>\n<p><\/b><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Velden kiezen (Naam, Titel, Rapporteert aan, enz.)<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Exporteren naar Excel of CSV<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ol>\n<h3><span style=\"font-size: 18pt\"><b>Optie B: VBA-macro gebruiken<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Gebruik indien nodig een VBA-macro om bijgewerkte vormrelaties te extraheren. Hier is een eenvoudig voorbeeld:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Sub ExportOrgChartnaarExcel()<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Dim shp als Visio.Shape<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Dim xlApp Als Object<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Dim xlWB Als Object<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Dim rij Als Geheel getal<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Set xlApp = CreateObject(\"Excel.Application\")<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Set xlWB = xlApp.Workbooks.Add<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0xlApp.Zichtbaar = Waar<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0rij = 2<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(1, 1).Value = \"Naam\".<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(1, 2).Value = \"Titel\".<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(1, 3).Value = \"Rapporteert aan\".<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Voor elke shp in ActivePage.Shapes<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Als shp.Type = visTypeGroup Dan<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(row, 1).Value = shp.Cells(\"Prop.Name\").ResultStr(\")<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(row, 2).Value = shp.Cells(\"Prop.Title\").ResultStr(\")<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0xlWB.Sheets(1).Cells(row, 3).Value = shp.Cells(\"Prop.Manager\").ResultStr(\")<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rij = rij + 1<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Einde Als<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u00a0\u00a0\u00a0\u00a0Volgende shp<\/span><\/p>\n<p><span style=\"font-weight: 400\">Einde Sub<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 24pt\"><b>Stap 7: Delen en samenwerken<\/b><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><b>SharePoint\/OneDrive:<\/b><span style=\"font-weight: 400\"> Sla uw Visio-bestand op in de cloud voor toegang door het team<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>Integratie van teams:<\/b><span style=\"font-weight: 400\"> Organogrammen insluiten in een Microsoft Teams-kanaal<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>PDF exporteren:<\/b><span style=\"font-weight: 400\"> Gebruik <\/span><span style=\"font-weight: 400\">Bestand &gt; Exporteren &gt; PDF maken<\/span><span style=\"font-weight: 400\"> voor presentatie of afdrukken<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><b>PowerPoint exporteren:<\/b><span style=\"font-weight: 400\"> Gebruik <\/span><span style=\"font-weight: 400\">Tekening kopi\u00ebren<\/span><span style=\"font-weight: 400\"> om visuals in een diadeck te plakken<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Voordelen van deze opstelling<\/b><\/span><\/h2>\n<ul>\n<li style=\"font-weight: 400\"><b>Real-time visuele planning<\/b><span style=\"font-weight: 400\"> zonder ruwe gegevens te bewerken<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gemakkelijke updates wanneer de teamstructuur verandert<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Gecentraliseerde gegevensbron (Excel) voor rapportage<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Verbeterde communicatie met belanghebbenden met visuals<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Herbruikbare sjabloon voor lopende HR-activiteiten<\/span><span style=\"font-weight: 400\">\n<p><\/span><\/li>\n<\/ul>\n<h2><span style=\"font-size: 24pt\"><b>Gebruikscases<\/b><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><b>Afdeling<\/b><\/td>\n<td><b>Gebruikscasus<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Personeelszaken<\/span><\/td>\n<td><span style=\"font-weight: 400\">Planning van de inwerkstructuur<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">IT<\/span><\/td>\n<td><span style=\"font-weight: 400\">Rolgebaseerde kaarten voor toegangscontrole<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Projectteams<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tijdelijke teamorganisatie<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Financi\u00ebn<\/span><\/td>\n<td><span style=\"font-weight: 400\">Budgettering op basis van hi\u00ebrarchie<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Operatie<\/span><\/td>\n<td><span style=\"font-weight: 400\">Rapportage-workflows<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span style=\"font-size: 24pt\"><b>Tips voor probleemoplossing<\/b><\/span><\/h2>\n<table>\n<tbody>\n<tr>\n<td><b>Probleem<\/b><\/td>\n<td><b>Oplossing<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Slepen en neerzetten werkt niet<\/span><\/td>\n<td><span style=\"font-weight: 400\">Zorg ervoor dat u in <\/span><b>Normale weergave<\/b><span style=\"font-weight: 400\"> en vormen zijn niet vergrendeld<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Afbeeldingen verschijnen niet na slepen<\/span><\/td>\n<td><span style=\"font-weight: 400\">Foto's na de verhuizing handmatig opnieuw toewijzen<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Grafiek geeft wijzigingen in Excel niet weer<\/span><\/td>\n<td><span style=\"font-weight: 400\">Vernieuw gegevensbron van <\/span><b>Gegevens &gt; Vernieuwen<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Lay-out is onoverzichtelijk<\/span><\/td>\n<td><span style=\"font-weight: 400\">Gebruik <\/span><b>Pagina opnieuw opmaken<\/b><span style=\"font-weight: 400\"> van tabblad organigram<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">Macro beveiligingswaarschuwing<\/span><\/td>\n<td><span style=\"font-weight: 400\">Macro's inschakelen via <\/span><b>Bestand &gt; Opties &gt; Vertrouwenscentrum<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Een slepen-en-neerzetten organogram-bouwer maken met behulp van<a href=\"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/product\/microsoft-office-2021-professional-plus-microsoft-visio-2024-professional-lizenz-fuer-3-pc\/\"> MS Office 2021 Pro Plus + MS Visio 2024 Pro<\/a> transformeert statische teamstructuren in dynamische visuele hulpmiddelen. Door de gestructureerde gegevens van Excel te koppelen aan de ontwerpmogelijkheden van Visio, ontsluit u een krachtig systeem voor organisatorische planning, personeelsbeheer en bedrijfstransparantie.<\/p>\n<p><span style=\"font-weight: 400\">Deze oplossing vermindert niet alleen de handmatige werklast, maar zorgt er ook voor dat grafieken up-to-date, interactief en gemakkelijk te delen zijn binnen de organisatie. Het is een onmisbare toolset voor moderne HR- en ops-teams.<\/span><\/p>\n<h2><b>FAQs<\/b><\/h2>\n<p><b>1. Kan ik foto's toevoegen aan elke werknemersvorm in Visio?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ja. U kunt met de rechtermuisknop op een vorm klikken en \"Foto vervangen\" selecteren om voor elk teamlid een afbeelding te uploaden.<\/span><\/p>\n<p><b>2. Kan ik de Excel-gegevens bijwerken vanuit Visio na het herschikken?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Niet direct, maar u kunt de bijgewerkte structuur exporteren via Shape Reports of VBA-macro's.<\/span><\/p>\n<p><b>3. Is de sleep-en neerzetfunctie beschikbaar in alle versies van Visio?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Het wordt ondersteund in Visio Professional-versies, inclusief Visio 2024 Pro. Zorg ervoor dat vormen niet vergrendeld zijn.<\/span><\/p>\n<p><b>4. Hoe ga ik om met grote organigrammen met 100+ werknemers?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Gebruik containers, swimlanes of meerdere pagina's. U kunt in Visio ook ondergeschikten samenvouwen om weergaven te vereenvoudigen.<\/span><\/p>\n<p><b>5. kan dit worden geautomatiseerd voor terugkerende updates van organogrammen?<\/b><\/p>\n<p><span style=\"font-weight: 400\">Ja. Met Power Query of VBA kunt u Visio-diagrammen volgens een schema verversen vanuit bijgewerkte Excel-bronnen.<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>Organizational charts are essential for understanding team structures, managing personnel, and communicating internal hierarchies. But building org charts manually can be time-consuming\u2014especially when roles change frequently. That&#8217;s where the power of automation and interaction in Microsoft Visio 2024 combined with Excel 2021 can help. In this guide, we\u2019ll walk you through building a drag-and-drop org [&hellip;]<\/p>\n","protected":false},"author":8326,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[128],"tags":[],"class_list":["post-215066","post","type-post","status-publish","format-standard","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Build Drag-and-Drop Org Charts Visually<\/title>\n<meta name=\"description\" content=\"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/drag-drop-org-chart-builder-visio-excel\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build Drag-and-Drop Org Charts Visually\" \/>\n<meta property=\"og:description\" content=\"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/drag-drop-org-chart-builder-visio-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Deutsch\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-10T09:10:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T17:36:34+00:00\" \/>\n<meta name=\"author\" content=\"pushkar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"pushkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/\"},\"author\":{\"name\":\"pushkar\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/#\\\/schema\\\/person\\\/2ff10edf55f2adbd05bfe6eb8b8c658c\"},\"headline\":\"How to Create a Drag-and-Drop Org Chart Builder Using Visio 2024 and Excel 2021\",\"datePublished\":\"2025-07-10T09:10:28+00:00\",\"dateModified\":\"2025-07-31T17:36:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/\"},\"wordCount\":1146,\"articleSection\":[\"Blog\"],\"inLanguage\":\"nl-NL\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/\",\"url\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/\",\"name\":\"Build Drag-and-Drop Org Charts Visually\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/#website\"},\"datePublished\":\"2025-07-10T09:10:28+00:00\",\"dateModified\":\"2025-07-31T17:36:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/#\\\/schema\\\/person\\\/2ff10edf55f2adbd05bfe6eb8b8c658c\"},\"description\":\"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/drag-drop-org-chart-builder-visio-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create a Drag-and-Drop Org Chart Builder Using Visio 2024 and Excel 2021\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/#website\",\"url\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/\",\"name\":\"Deutsch\",\"description\":\"Kaufen Sie Ihr Office\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/#\\\/schema\\\/person\\\/2ff10edf55f2adbd05bfe6eb8b8c658c\",\"name\":\"pushkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g\",\"caption\":\"pushkar\"},\"url\":\"https:\\\/\\\/technikmarkt-aschaffenburg.de\\\/deutsch\\\/nl\\\/author\\\/pushkar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build Drag-and-Drop Org Charts Visually","description":"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.","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:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/drag-drop-org-chart-builder-visio-excel\/","og_locale":"nl_NL","og_type":"article","og_title":"Build Drag-and-Drop Org Charts Visually","og_description":"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.","og_url":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/drag-drop-org-chart-builder-visio-excel\/","og_site_name":"Deutsch","article_published_time":"2025-07-10T09:10:28+00:00","article_modified_time":"2025-07-31T17:36:34+00:00","author":"pushkar","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"pushkar","Geschatte leestijd":"7 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/#article","isPartOf":{"@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/"},"author":{"name":"pushkar","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/#\/schema\/person\/2ff10edf55f2adbd05bfe6eb8b8c658c"},"headline":"How to Create a Drag-and-Drop Org Chart Builder Using Visio 2024 and Excel 2021","datePublished":"2025-07-10T09:10:28+00:00","dateModified":"2025-07-31T17:36:34+00:00","mainEntityOfPage":{"@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/"},"wordCount":1146,"articleSection":["Blog"],"inLanguage":"nl-NL"},{"@type":"WebPage","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/","url":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/","name":"Build Drag-and-Drop Org Charts Visually","isPartOf":{"@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/#website"},"datePublished":"2025-07-10T09:10:28+00:00","dateModified":"2025-07-31T17:36:34+00:00","author":{"@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/#\/schema\/person\/2ff10edf55f2adbd05bfe6eb8b8c658c"},"description":"Learn to create a dynamic, drag-and-drop org chart builder using Visio 2024 and Excel 2021 to streamline team structure visualization and planning.","breadcrumb":{"@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/drag-drop-org-chart-builder-visio-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/"},{"@type":"ListItem","position":2,"name":"How to Create a Drag-and-Drop Org Chart Builder Using Visio 2024 and Excel 2021"}]},{"@type":"WebSite","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/#website","url":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/","name":"Duits","description":"Koop uw Office","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Person","@id":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/#\/schema\/person\/2ff10edf55f2adbd05bfe6eb8b8c658c","name":"pushkar","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b9c200a342a909cc91092dac06b219a5b7f384f014dc6fa7e1859dca7c984ba6?s=96&d=mm&r=g","caption":"pushkar"},"url":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/author\/pushkar\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/posts\/215066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/users\/8326"}],"replies":[{"embeddable":true,"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/comments?post=215066"}],"version-history":[{"count":0,"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/posts\/215066\/revisions"}],"wp:attachment":[{"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/media?parent=215066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/categories?post=215066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/technikmarkt-aschaffenburg.de\/deutsch\/nl\/wp-json\/wp\/v2\/tags?post=215066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}