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
Posted May 12, 2026, 2:58 PM UTC
10