How to Create Sankey Diagram in Excel? Easy Steps

Video Tutorial:

In the following video, you will learn how to make a Sankey Chart in Excel without any coding in a few clicks:

Top 5 Excel Sankey Diagram Templates with Examples

Plenty of data visualizations in Excel can be used to represent the flow of resources or information between multiple entities. These are particularly useful for illustrating the distribution, allocation, or transition of quantities such as energy, materials, costs, or other resources.

Now we will discuss some of the most commonly used examples, which are as follows:

1. Job Application Analysis Example
2. Sentiment Analysis Example
3. Presenting Financial Flows Example
4. Package Delivery Analysis Example
5. Store Order Analysis Example

Example #1: Job Application Analysis

Recruiting is one of the undertakings that can produce monstrous data. As a human resource professional, you’ve got to track requests for employment until the onboarding stage.

The data produced en route can help inform future decision-making processes. This is where this chart becomes very important. The chart can assist you with refining recruiting data into significant insights by visualizing the whole data flow of the Job Application Tracker system.

What’s more, this can save lots of hours, which you can use to unwind or execute different assignments.

The visualization above tracks the job application flow from the recruitment phase to onboarding.

Example #2: Sentiment Analysis

You can use the chart to track the sentiments of a particular niche market towards a brand or its offerings.

The example above tracks market sentiments toward a fast-food brand.

Example #3: Presenting Financial Flows

You can use this chart to track and analyze the cash flow diagram in Excel from cash sources to the final recipients.

Example #4: Package Delivery Analysis

The example above tracks the packages from dispatch to the intended consumers. The final recipients are segmented based on their country of residence.

Example #5: Store Order Analysis

The chart can also be used to track online store orders to prevent problems, such as loss of packages along the way. Also, you can use the Sankey charts in Excel to track products sold based on their respective brands.

What is the best Sankey Diagram Generator in Excel?

The next step is to understand what the Sankey graph creator in Excel is.

To satisfy your curiosity, we have an incredible tool called ChartExpo, a powerful add-in that lets you create a Sankey graph in Excel effortlessly.

The reasons why we recommend ChartExpo to you are:

• Affordability
• User Interface friendliness
• Quality of the charts

ChartExpo has an incredible score in the factors we have briefly discussed.

That’s not all.

It means you don’t need sophisticated programming or coding knowledge to work around the Sankey chart generator in Excel. This Sankey graph builder in Excel will help you obtain meaningful insights from your bulky data.

Also, this chart maker in Excel makes charts that you can easily interpret, even for an audience that is not familiar with non-technical topics.

How to Create a Sankey Diagram in Excel?

Before we get down to business, here is a fun fact you need to know about Excel.

Excel has billions of users because it is our most common spreadsheet. With this spreadsheet in your office tool, you can create a Sankey graph in Excel. Here is the truth: an Excel worksheet does not have a Sankey graph in Excel; it’s a list of graphs. Excel is limited to a few basic charts.

But don’t lose hope just yet. There is a solution to our problem. You want to know what it is. Let’s get to it.

What is the solution?

Think about this for a moment. If Excel does not have this chart, how can we create one? One of the crucial actions you can take is to supercharge it with an Excel

add-in to create charts in Excel.

One of the most useful tools is ChartExpo, a reliable add-in for visualizing data effectively. In other words, it serves as a powerful Sankey chart generator in Excel.

This online tool works smoothly in any browser, ensuring a stable experience while you create and customize your charts.

In addition, ChartExpo is an affordable add-in for most users. When you want to use it, you won’t incur any cost. It is available for you to use in your data analysis.

Let us explain ChartExpo and how it can help you as a data analyst.

What is ChartExpo?

In brief, ChartExpo is an add-in that utilizes cloud-hosting features to create data visualizations. This add-in to your Excel worksheet allows you to create many graphical presentations. It is one of the simplest add-ins for your Excel charts.

But that is not all.

You do not need a fancy manual to work your way around the add-in. This is because it takes quick and easy steps to create a chart of your choice. If you ever find yourself in a dilemma about which chart to use, ChartExpo has got you covered.

Let us dig deeper using a practical example:

To get started, install the ChartExpo add-in for Excel using the Sankey Generator in Excel.

• Click on your Excel spreadsheet to open your workbook.
• On your worksheet menu, click on Insert.
• The Insert menu will display the My Apps.

• Select the ChartExpo add-in and click Insert.

• Click on the “Sankey Chart” in the list of available charts in Excel, as shown below.

• After selecting the data, click on the Create Chart From Selection button, as shown below.

• Check out the final Diagram below.

How to Edit a Sankey Chart in Excel?

You can edit the Sankey chart in Excel with the colors you choose and add a heading. Click Edit Chart.

Here are some of the insights from your table that will appear like this in your chart.

Amount of Energy Used

Energy from Nuclear Sources

Multi-Level Sankey Builder in Excel

You can create a multi-level Sankey chart in Excel if your data contains multiple layers of information. In the example above, we easily built a multi-level chart in Excel with just a few clicks because the data was well-structured.

Application of Sankey Graph

• Presenting survey results
• A website’s customer base for digital marketing
• Supply chain administration
• Visualize Funds Flow
• Visualizing hierarchical data
• Energy Administration
• Visualizing the customer journey
• Revenue information, particularly for budgetary and monthly cash flow.

What Types of Data Can Be Visualized Using This Chart?

Many people seem to get worried about identifying the specific type of data mainly used by Sankey in Excel:

This is a question that needs a lot of interpretation to eliminate confusion. The reality is that examples are mainly used to identify weighted networks, such as flows.

In other words, your data should have flow-like attributes.

The diagram’s nodes are depicted in two or more categories that represent various data stages. Once you’ve outlined your data properly, it becomes easier to analyze it and generate essential insights.

These diagrams are magnificent, especially in communicating flow systems. They can assist with uncovering examples and help in investigating, tracking down bottlenecks, or showing clients how cycles flow.

Plus, they prove to be useful, particularly in addressing large volumes of data.

The flow of data through a system, a process, or even a decision process can undoubtedly be examined for in-depth insights.

While investigating what is happening, it’s frequently challenging to get to the root of a problem. An example can show where the issue exists and what it might mean for the general framework.

So, when should you not use this diagram?

Limitations

Creating a Sankey chart in Excel without add-ins can be challenging and time-consuming. Here are some key limitations:

• No Built-in Option: Excel doesn’t have a native Sankey plot type, so you must manually design flows using shapes or lines.
• Complex Setup: Building and adjusting flow connections between nodes takes significant effort and can easily lead to errors.
• Difficult Customization: Changing flow width, colors, or labels requires manual formatting, which limits flexibility.
• Poor Data Updates: When data changes, the chart doesn’t update automatically—you have to rebuild or adjust it manually.
• Limited Visualization Quality: Manually created Excel Sankey charts often lack smooth transitions, consistent scaling, and a professional appearance.

Best Practices

• Keep It Focused: Highlight only the key data flows that matter most to your analysis to avoid clutter and confusion.
• Use Meaningful Colors: Apply consistent and intuitive color schemes to distinguish categories or processes clearly.
• Label Key Elements: Add clear labels to nodes and flows so viewers can quickly understand what each part represents.
• Use an Add-in for Efficiency: Tools like ChartExpo make it simple to create, edit, and visualize this chart without complex setup or coding.

FAQs

How do I create a Sankey chart in Excel?

Create a Sankey plot in Excel with just a few clicks—no coding required. Simply follow the steps below.

• Step 1: Open your Excel Application.
• Step 2: Click Insert>My Apps>ChartExpo for Excel.
• Step 3: Look for the Sankey Chart in the charts list.
• Step 4: Select your data and click Create Chart From Selection.
• Step 5: You will get the Sankey plot in Excel, which you can edit and customize.

To better learn with the help of images, you can read our blog on how to create a Sankey Diagram in Excel, or you can watch a video tutorial on the Sankey plot in Excel here.

Can you make a Sankey diagram in Excel?

Yes, you can achieve this by downloading and installing an Excel add-in for creating a Sankey diagram called ChartExpo. This is because Excel lacks chart templates for Sankey.

ChartExpo has several templates of charts. With ChartExpo, you can create a Sankey Visualization in Excel.

What is the free Excel add-in for Sankey diagram?

Wrap Up

Let’s recap everything we’ve discussed.

We now know that a Sankey Chart in Excel is one of the most effective ways to capture your audience’s attention and present your data story clearly.

If you’re working in Google Sheets or Power BI, you can also create similar visuals by following our guides on these platforms.

A Sankey Diagram in Excel makes it easy to visualize complex data flows and highlight key insights, helping your audience quickly understand the most important parts of your analysis.