•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I built an Excel automation that turns a table into an org chart
Our take
In a quest to streamline the creation of organizational charts, I developed an Excel automation tool that transforms a simple table into a visually coherent org chart. As someone in internal control, I often face the challenge of building these charts manually in PowerPoint or Visio, which can become chaotic when team structures evolve. By inputting employee-manager relationships directly in Excel, the org chart is generated automatically.
I work in internal control and often need to build org charts for teams or departments.
Doing it manually in PowerPoint or Visio quickly becomes messy when the structure changes.
So I tried to automate the process directly in Excel.
The idea is simple: you write the hierarchy in a table (employee / manager) and the org chart is generated automatically.
This was mostly an experiment to see how far Excel automation could go.
I'm curious how other Excel users would approach this problem.
Would you structure the hierarchy differently or automate the org chart another way?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Dynamic Org chart (7k employees)For learning / exploration purposes only. I have an Excel file with ~7,000 employees and basic hierarchy fields (employee, manager, etc.). I’m trying to figure out if there’s any reasonable way to build a dynamic org chart in Excel — something that can expand/collapse, filter by team, or at least explore reporting structures. Not expecting a perfect visualization at this scale, but curious if anyone had any ideas? submitted by /u/Few_Suit_7199 [link] [comments]
- Cleaning up Excel → PowerPoint workflow for monthly management reportsEvery month I build a management report for board-level distribution. Current workflow: Pull data from source into Excel Build charts in Excel Paste charts into PowerPoint template Spend 45-60 minutes fixing alignment, font sizes, and chart formatting that shifts on paste Export to PDF The main friction points I haven't been able to solve: — Charts lose formatting consistency when pasted across slides (colours shift, font sizes change) — When source data updates I have to rebuild or re-paste rather than refresh — Maintaining consistent styling across 10-15 slides is manual and error-prone I've tried Paste Special → Picture to lock formatting but then charts aren't refreshable. I've tried linking charts directly but the formatting still drifts. We have Power BI available but it's worse for this specific use case, visual customization is too limited for board-level output and the document format is painful to work with. Has anyone solved the refresh + consistent formatting problem in a clean way? Specifically looking for an approach that works across 10-15 slides monthly without rebuilding from scratch each cycle. submitted by /u/Top-Ant-4492 [link] [comments]
- Formula to achieve more complex text to columns?Hi everyone! I'm back with my latest question in my journey to maximize excel's usefulness in my office! Currently, I'm trying to figure out how to autofill a table and from there auto convert to a chart. To explain: The spreadsheet is tracking productivity goals for our employees (specifically the goals are to move x amount of clients into different statuses each month). As the employees complete these tasks, they are posting a message in a central teams chat with the information status, client name, client number, caseload, and the date. Once a week, management goes through the chat and copies and pastes the information into a spreadsheet broken up by employee and status. Every month, they use the data from that sheet to fill in a chart that counts them and calculates percentage of the goals met. Management asked me to find a way to take the monthly task of filling in the chart off their hands by making that automated. The way I was going to do this was to convert their sheet into a table and then use the table to create the chart. However, upon opening the spreadsheet, I see how much management has been just copy and pasting the raw data underneath each caseload's heading. I don't want to make more work for them by making them fill in the table, so I'm trying to find a way to automate this to. I thought about text to columns, but everyone's doing things slightly differently in their posts in the teams chat so that makes this a little difficult. The status is pretty universally first with a dash between that and the name with is almost universally second. After that some people are not including separation between name and client number, some people are using commas, some people are using dashes, some people are using a pound sign, and some people are putting the leading zeros. So it's really messy. Obviously, I can ask management to set the expectation that this be uniform and they would be happy to do that. But I want to see if there's a way we can do this easily without changing the already existing process. Does anyone have ideas? Thank you for reading all of this and helping!! submitted by /u/tashykat [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#automation in spreadsheet workflows#generative AI automation#workflow automation#cognitive automation#natural language processing for spreadsheets#generative AI for data analysis#interactive charts#Excel#org chart#automation#hierarchy#employee#manager#internal control#process#table