[Click here to find all my Sankey Chart series]

Sankey charts have many use cases. One of the users asked me how to sort the output/target, group those smaller outputs on the right side in a single category named Others and only keep the top few. That makes sense because they are of lesser importance and it helps viewers focus on the bigger outputs. There we go with a custom design template for the use case.

Here are the steps:

1.Download and open the template workbook

2.Add your data source and UNION it with itself.

3.Rename two dimensions as Source and Target. And rename one measure as Size.

Note that in Sankey chart, we may interchangeably use Source/Target, Input/Output, Left/Right to refer to the same two dimensions on both sides of the chart.
5

[Click here to find all my Sankey Chart series]

A reader of my tutorial on Sankey Chart via Template asked me how to group the Source members on the left side of the chart. Yes, when there are too many members in a dimension, grouping them makes the chart much cleaner.

I spent some time to design a new template for this type of application. Here is how it works.

Left Side Grouping

1.Download and open the template workbook for Sankey with Grouping.
4

Comparison is an important objective of data visualization, by which we derive insights in a cohort.

Trellis chart is an interesting way to visualize a large cohort of data. But sometimes we may get lost in the repetition of the same chart type. That is it may not be easy to make some of the cohort standing out. Th choice of chart types can impact the contrast between the members of the cohort.

Here the contrast is not at the pixel level of luminosity, but at the chart level.

[A Template Approach to 3-Stage Sankey Chart]

[Click here to find all my Sankey Chart series]

Since I published the basic 2-stage Sankey chart template, five of my colleagues with rudimentary Tableau skills created Sankey charts for their respective projects using the template. Their charts were so good which went beyond my wildest imaginations.

Following the publication of the template, many asked me how to create a 3-stage one. Here comes the tutorial.
13

This is a stacked bar chart on contribution of sales per segment per month in percentage.

Today we would like to create a radial alternative of the same chart. 

The key idea is using Polygon as data mark to generate each color block. And we will use 100 points for drawing the contour of each Polygon, or the path.

The steps are as follows:

- Union the data table with itself. This will generate a new column Table Name with two table names.
11
Blog Archive
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.