• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Make a Sankey Diagram in Excel

October 2, 2021 by Andrew Childress
Sankey diagram in Excel

A Sankey diagram is a special type of flow diagram used to illustrate values. Let’s learn how to make a Sankey diagram in Microsoft Excel.

A Sankey diagram is a special type of flow diagram used to illustrate values. Sankey diagrams are notable because their arrow width is always proportional to the rate of flow. While these aren’t buildable with native Excel features, you can easily do it with an add-in. Let’s learn how to make a Sankey diagram in Microsoft Excel.

How to Make a Sankey Diagram in Excel

Sankey diagram charts are quite easy to create in Microsoft Excel. You’ll need two things to do it easily:

  • A data table. These are the values that Excel will use to draw your Sankey diagram.
  • The Power User add-in. Excel add-ins are additional feature sets that you can add to your Excel installation. This helps you expand the versatility of your install by bringing in customized features not included by default in the app.

To download Power User, go to https://www.powerusersoftwares.com and click on the red Download button at the top of your screen. Once the file downloads, open the downloaded .exe file and install the add-in. Then, open Excel.

In Excel, go to the File > Options menu. Click on Add-ins, where you’ll see the Power-user option listed. Go ahead and activate it, then click OK.

Sankey chart Excel

Excel now has a new tab on the ribbon: Power-user. Click on this to open the Power User features. Notice on the left side the button you’re looking for: Create Sankey Chart.

Sankey diagram in Excel

Click on Create Sankey Chart. You’ll be asked to select the data source, which is the data that will be used to create your chart. Click and drag to select the range, which here is A1:D4.

How to make a Sankey diagram in Exel

When you’re finished, click OK. The Power User add-in will instantly draw a beautiful Sankey chart on your Excel sheet. You can move it around and manipulate it just like any other chart in Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Circle invalid data in ExcelCircle Invalid Data in Excel
Next Post:How to Calculate AIC in ExcelAkaikes information criterion Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top