Sankey charts

Modified on Wed, 27 Jul 2022 at 07:02 PM

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



TABLE OF CONTENTS



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.


Power-user l Sankey chart



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.


Power-user l Sankey chart data source




Editing and customizing a Sankey


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. 


Sankey chart l Chart Options


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.
Sankey chart l Series Options



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.



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us how can we improve this article!

Select atleast one of the reasons

Feedback sent

We apprciate your effort and will try to fix the article