How to Create & Use Data-Driven Content for Link Building

How to Create & Use Data-Driven Content for Link Building

Data-driven content must be exciting, eye-catching, and unique. Here's how to choose the right topic and create a powerful piece of content that attracts links naturally.

How to Create an Organizational Chart Linked to Data in Excel (Easy & Dynamic)

Creating an organization chart in Excel has never been easier! The best part is it’s dynamic because it’s linked to cells.

Organizational Charts (Org Charts) or Organigrams are used in companies to graphically show the internal structure of the organization. The employees are usually represented by boxes and the chart also shows the relation of the positions to another. This is a great way to visualize an organization.

Very often these Org Charts are created by using Excel Smart Art or Excel Shapes. But this is not a dynamic solution. Every time anything changes, the chart has to be manually updated. This is very time consuming and error prone. In this video I’ll show you an easier and dynamic alternative using Excel and a free Visio add-in from in Office 365 (no Visio subscription is required). With this, we can create automatically create an organization chart from employee data. The org Chart will be dynamic too, because it will be linked to cell values.

The basis for the organizational chart is an Excel table containing the required information like departments, employee names, employee IDs, job titles, who the position is reporting to, and so on. The organization chart is created by using the Microsoft Visio Data Visualizer add-in which is a free tool in Office 365.

After selecting the chart type in the Visio Data Visualizer it creates a draft org chart and a connected Excel data template. All we have to do is to bring over the actual organizational information into this data template. Then hit Refresh in the chart area and the organization chart is automatically updated.

Every time there is a change in the organization just update the data table and hit Refresh. The changes will be automatically reflected in the chart. The tool even includes a data checker that will inform you about data inconsistencies like empty or duplicate cell information.

In addition to organization charts the Visio Data Visualizer can also create different diagrams like Basic Flowcharts or Cross-Functional Flowcharts. This way, process steps and the required process flow can be visualized based on Excel data.

The final Organizational Chart can easily be printed or saved as PDF. In the chart area just click on More Options and select Open in Web. From there you can directly send the chart to the printer or Download as PDF.

Please note that in order to edit the appearance of the diagram in the Visio Data Visualizer you need to have an Office 365 subscription with a license for Visio.

The Microsoft Visio team was very kind to provide an email address to contact if you run into issues with the add-in. Send an email describing your problem to: [email protected]

00:00 Organization Chart in Excel
01:39 Install Microsoft Visio Data Visualizer Add-in
02:25 Create Organizational Chart with Automatic Refresh
06:40 Create a Flow Chart in Excel

⯆ DOWNLOAD the workbook here:

Excel infographic chart templates:
Excel Advanced charts playlist:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


Get Office 365:
Microsoft Surface:

Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:

More resources on my Amazon page:

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!


Create a Content Calendar That Drives Impact in B2B SEO

This episode of The SEO Lounge teaches you how to marry your content marketing strategy with SEO drive significant business growth.

Highly regarded SEO and IMG Instructor, Viola Eva, will walk marketers through a six step content planning formula to increase high intent traffic significantly.

Powered by Restream

SEO & Content: How to Build More Than Just Links

If you are practicing a short-sighted content marketing campaign and struggling to produce results, perhaps it’s time to take a step back and look at the big picture.

Loren Baker, Founder at SEJ and VP of Business Development & Co-founder at Foundation Digital, will let you in on how you can gain maximum SEO value – and more – through content.

Subscribe to our channel to learn more about Online Marketing!

BristolSEO – June 2020 – Data Driven Content Marketing, Link Building & Schema

Talk: Using Schema during a time of crisis: what can we learn for search?

Schema is an exceptional tool to have in your back pocket as an SEO, but a lot of marketers don’t see its full benefit. Schema can be applied during times of uncertainty to assist searches where consumers are looking for accurate, up to date information. In this talk, I’ll explore what opportunities we can take with schema for the future of search.

Beth Barnham – SEO Specialist, Liberty Marketing

Beth is an SEO Specialist with a love for technical SEO. Having worked in various digital marketing roles for three years, she now uses all her learned digital marketing skills to hone in on SEO. She’s passionate about knowledge sharing and collaborative learning.


Talk: How To Get Big Links Without A Big Budget

The last few months have been the most fraught of my career, dealing with budget cuts, campaign pauses and a media that seemingly only wants to talk about one thing – coronavirus. My role at Propellernet is to secure our clients links through digital PR, and myself and the team have had to adapt pretty quickly but our change in tact has led to us build over 400 links. My talk will go into how great digital PR campaigns don’t need to cost the world and how you can maximise the amount of links you secure with each story.

Louise Parker – Digital PR Director, Properllnet

Louise has worked in Digital PR for 5 years, securing coverage and links for brands like Premier Inn, Kuoni, carwow and PureGym. She specialises in creating link building strategies that both excite journalists and connect with a brand’s audience. She also makes incredibly niche TikTok videos about digital PR (@louise_digitalpr).


Talk: 6 steps to create a data-driven content strategy

Learn how to include search data into content creation and optimization.

In this talk, we’ll look at:

– How to create content that meets the expectations of your target audience

– How to use search intent to know what users want

– Learn how to identify relevant topics

– How to select the right type of content

Lisiane Ndong – Client Success Manager, Searchmetrics

Lisiane is Client Success Manager at Searchmetrics, the leading global enterprise platform in SEO analytics and Content Marketing.
Before joining Searchmetrics, she was working at The Insiders, responsible for managing local and global Influencer Marketing campaigns for FMCG and Consumer Electronics companies (Samsung, Nestle, Panasonic).

Prior to working at The Insiders, Lisiane founded an e-commerce brand, Sapelle and worked for Kelkoo, responsible for Pay Per Click advertising, and web analytics.

In parallel, Lisiane is Lecturer in Digital Marketing at Pearson College London.