Power-user is the only tool on the market for creating Sankey charts in Excel. 

TABLE OF CONTENTS

• About Sankey charts
• Creating a Sankey chart with Power-user
• Editing and customizing a Sankey
  • Chart Options
  • Series Options

About Sankey charts

Sankey charts are ideal to represent flows such as Internet traffic, or international flows of capital, migrants or trade.

For instance, have a look at the chart below. On the left you have 7 sources of Internet traffic, with their respective shares and how each of them contribues to the traffic of 3 websites. You can see the share of each source of traffic for each website and in total.

Creating a Sankey chart with Power-user

Currently, Sankey charts can only be created from the Excel ribbon of Power-user. 

• From Excel, click Create Sankey chart.
• A dialog box will open, asking you to select the data source.
• Select your data, including the row and column headers, and click OK to validate. The chart will be created automatically.

Your data should be organized in a table of rows and columns. Position the field for the origin in rows, and the field for the destination in columns.

Editing and customizing a Sankey diagram

After you create a Sankey chart, the edition pane will open on the right of your screen. To open it later, right-click the chart and click Edit Sankey chart.

Chart Options

From the Chart Options tab of this edition menu, you can:

• Add, remove or edit the title of your chart.
• Edit the color for the borders of the Sankey.
• Hide or show totals for Series, Categories, Labels or the overall chart, as values and/or as percentages.
• Change the number format with a specific number of decimals for either values and/or percentages. 

The chart labels will automatically be formatted the same way as the cells in your data source. So if you wish to edit the format of your labels, you can just format the source and update the chart.

Series Options

To edit the format of a specific Series on your chart, click the second tab, Series Options. From this menu you can select a specific Series from your chart, and then:

• Change the fill color for this Series only.
• Change the color, font size etc. of the labels for that data Series.

Multi-level Sankey
Power-user only allows you to create Sankey with 1 level, i.e. it's not possible to have intermediary steps in the Sankey chart. We are working to enable this possibility in the future.