1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Dynamic network graph built entirely in Excel using VBA

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.

Interactive Excel w/ VBA Network Graph and Dashboard

submitted by /u/nlomb
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#cloud-based spreadsheet applications
#interactive charts
#dynamic network graph
#Excel
#VBA
#customer relationships
#visualize
#VBA logic
#visualization
#counterparty exposure
#transaction flows
#interactive
#dynamic
#nodes
#connection paths
#dynamically shown