Here, Screaming Frog, Excel and ToughGraph Navigator have been used to create the finished visualisation.
This should allow you to visualise which pages on a site have the greatest volume of internal site links, and identify areas which have too many or too few internal links pointing towards them.
You can easily use similar methods to identify where on the site has the most number of external back links, allowing you to identify pages which could benefit from building additional back links, and pages that have been targeted with too many back links, therefore possibly appearing spammy.
Step 1: Gather Your Data
Clean your data by gathering only the internal linking URLs, with the corresponding volume of internal links to each URL, by using a pivot table.
Step 2: TouchGraph Navigator
Step 3: Visualise!
Step 4: Data Visualisation
You should be able to see which pages have the greatest volume of internal links, connecting them to the rest of the site.