•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Dynamic network graph built entirely in Excel using VBA and Pivot Tables
People tend to underestimate the power of Excel.
This dynamic network graph was built entirely in Excel using VBA to visualize customer relationships, counterparty exposure, and transaction flows.
All nodes and connection paths are pre-drawn Excel shapes that are dynamically shown, hidden, resized, and weighted through VBA logic based on filters and relationship strength.
Link to the Excel file and Pivot Table explanation: Gitlab Repo - Excel Network Graph Dashboard
[link] [comments]
Want to read more?
Check out the full article on the original site