• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

How to Create a Custom Sankey Diagram in Google Sheet?

You can use Sankey Charts to visualize data with flow-like attributes, such as material, energy, cost, finance etc. An energy flow diagram is a type of Sankey diagram that tracks the flow of energy from raw or primary sources of energy.

Interactive Sankey Diagram
Sankey chart

This interactive Sankey diagram draws the reader’s attention to the enormous flows, the largest consumer, the major losses, and other insights. Besides, Sankey uses links and nodes to uncover hidden insights into relationships between critical metrics.

Types of Sankey Chart Supported by ChartExpo

Interactive Sankey diagram in ChartExpo offers every type of Sankey. You can choose levels from 2 levels to 8 levels.

Table Of Content

  • How to do data formation for Sankey Chart?
  • Let’s Draw 2 levels “Sankey Chart” in Google Sheets
  • Let’s Draw 3 Levels Sankey Chart in Google Sheets
  • Let’s Draw 4 Level Sankey Chart in Google Sheets
  • Understand Different Properties for Sankey Chart
  • How does Add chart to sheet and Export works?

Case Study

You have the data of different delivery services. You need the information to give better understanding of services to stake holders.

In this guide, we will discuss 2, 3, 4 levels to create Sankey chart. Let’s begin.

Video Tutorial:

Sankey chart

How to do data formation for Sankey Chart?

Tabular data for Sankey Chart should include levels, counts.

Levels are the nodes where counts are the numbers.

  • The size of a node is directly proportionate to the quantity of the data point under review.
  • Each flow has a varying height depending on its quantity to help.

For example you have data of different logistic companies, you have 2 levels data and you used Sankey Chart for showing flow. Delivery Services is first level and countriesHow to do data formation for Sankey Chart? is second level. Deliveries is metric for Sankey chart.

Delivery ServicesCountriesDeliveries
United PackageUSA3881
United PackageGermany2673
United PackageAustria2670
United PackageBrazil1424

Let’s Draw 2 levels “Sankey Chart” in Google Sheets

Here are few details you need to know while creating Sankey Chart in Google Sheets.

Prerequisite Understanding

For every node specific metric is provided. Which will be required by chart to draw the visualization. You need 3 columns for creating 2 levels Sankey Chart. First column will contain data of first level from left, second column will contain second level, third column will contain metric for each node that should be numeric type.

Prepare data for 2 node Sankey Chart

Your data should be prepared as shown below.

Delivery ServicesCountriesDeliveries
United PackageUSA3881
United PackageGermany2673
United PackageAustria2670
United PackageBrazil1424
United PackageIreland1530
Federal ShippingUSA4266
Federal ShippingGermany1684
Federal ShippingAustria1546
Federal ShippingBrazil1736
Federal ShippingIreland2930
Speedy ExpressUSA2997
Speedy ExpressGermany1572
Speedy ExpressAustria2255
Speedy ExpressBrazil1223
Speedy ExpressIreland1757
United PackageUSA2446
United PackageGermany1719
United PackageAustria2217
United PackageBrazil2633
United PackageIreland1738
Federal ShippingUSA2733
Federal ShippingGermany1669
Federal ShippingAustria1855
Federal ShippingBrazil1497
Federal ShippingIreland1638
Speedy ExpressUSA2675
Speedy ExpressGermany2239
Speedy ExpressAustria1801
Speedy ExpressBrazil1749
Speedy ExpressIreland996
United PackageUSA2314
United PackageGermany722
United PackageAustria1866
United PackageBrazil1947
United PackageIreland1661
Federal ShippingUSA2835
Federal ShippingGermany624
Federal ShippingAustria1473
Federal ShippingBrazil877
Federal ShippingIreland1535
Speedy ExpressUSA2409
Speedy ExpressGermany1200
Speedy ExpressAustria538
Speedy ExpressBrazil640
Speedy ExpressIreland1671
United PackageUSA1912
United PackageGermany774
United PackageAustria549
United PackageBrazil948
United PackageIreland796
Federal ShippingUSA1715
Federal ShippingGermany741
Federal ShippingAustria569
Federal ShippingBrazil463
Federal ShippingIreland862
Speedy ExpressUSA1606
Speedy ExpressGermany744
Speedy ExpressAustria890
Speedy ExpressBrazil665
Speedy ExpressIreland421
United PackageUSA1405
United PackageGermany788
United PackageAustria579
United PackageBrazil579
United PackageIreland687
Federal ShippingUSA1632
Federal ShippingGermany507
Federal ShippingAustria708
Federal ShippingBrazil729
Federal ShippingIreland493
Speedy ExpressUSA1652
Speedy ExpressGermany783
Speedy ExpressAustria403
Speedy ExpressBrazil538
Speedy ExpressIreland592

Once you are done with ChartExpo Add-on installation. You can now put the data in Google Sheets then go to Extensions, find Charts, Graphs & Visualizations by ChartExpo, and click on Open.

Interactive Sankey Diagram

Now click on Add New Chart button.

Interactive Sankey Diagram

You will find Sankey Chart in the list of charts.

Interactive Sankey Diagram

After click on the Sankey Chart you will find some attributes which should be filled to draw this chart.

Create Sankey Chart in 5 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Delivery Services.

Step 3: Select the column of Countries.

Step 4: Select the column of Deliveries.

Interactive Sankey Diagram

Step5: Once you filled these attributes you can click on Create Chart button.

Interactive Sankey Diagram
Interactive Sankey Diagram

Your 2 level Sankey chart is ready to present!

Click here to go directly to properties section.

Let’s discuss structure of Sankey Chart.

  • Chart is divided into two levels and each level have its own nodes and stats.
  • First level have nodes in first column you used.
  • Second level have nodes in second column.
  • Arrow highlighting with Stats is actually the metric(numbers) against each node.
Interactive Sankey Diagram

Let’s discuss few things about chart.

As you can notice in image that how beautifully ChartExpo has mapped levels, nodes and flow.

Node name is coming on the right of each node.

Each level is divided into different nodes and each nodes have its own flow. So the reader or viewer can easily understand different flows. If you look in this mapping you will notice that Level 1 is mapped on first column, level 2 is mapped on second column.

Interactive Sankey Diagram

There are few properties which you need to know which can help you to change the aesthetic of this chart. These properties are explained in detail after the section “Let’s Draw 4 Level Sankey Chart in Google Sheets”. You can click here to directly go to properties section.

Let’s Draw 3 Levels Sankey Chart in Google Sheets

Prerequisite Understanding

You need 4 columns for creating 3 levels Sankey Chart. First to third columns will contain data of node, and fourth column will contain metric for each node.

Prepare data for 3 level Sankey Chart

You have data of 3 level Sankey data.

PackagesDelivery ServicesCountriesDeliveries
BeveragesUnited PackageUSA3881
BeveragesUnited PackageGermany2673
BeveragesUnited PackageAustria2670
BeveragesUnited PackageBrazil1424
BeveragesUnited PackageIreland1530
BeveragesFederal ShippingUSA4266
BeveragesFederal ShippingGermany1684
BeveragesFederal ShippingAustria1546
BeveragesFederal ShippingBrazil1736
BeveragesFederal ShippingIreland2930
BeveragesSpeedy ExpressUSA2997
BeveragesSpeedy ExpressGermany1572
BeveragesSpeedy ExpressAustria2255
BeveragesSpeedy ExpressBrazil1223
BeveragesSpeedy ExpressIreland1757
Meat/PoultryUnited PackageUSA2446
Meat/PoultryUnited PackageGermany1719
Meat/PoultryUnited PackageAustria2217
Meat/PoultryUnited PackageBrazil2633
Meat/PoultryUnited PackageIreland1738
Meat/PoultryFederal ShippingUSA2733
Meat/PoultryFederal ShippingGermany1669
Meat/PoultryFederal ShippingAustria1855
Meat/PoultryFederal ShippingBrazil1497
Meat/PoultryFederal ShippingIreland1638
Meat/PoultrySpeedy ExpressUSA2675
Meat/PoultrySpeedy ExpressGermany2239
Meat/PoultrySpeedy ExpressAustria1801
Meat/PoultrySpeedy ExpressBrazil1749
Meat/PoultrySpeedy ExpressIreland996
Dairy ProductsUnited PackageUSA2314
Dairy ProductsUnited PackageGermany722
Dairy ProductsUnited PackageAustria1866
Dairy ProductsUnited PackageBrazil1947
Dairy ProductsUnited PackageIreland1661
Dairy ProductsFederal ShippingUSA2835
Dairy ProductsFederal ShippingGermany624
Dairy ProductsFederal ShippingAustria1473
Dairy ProductsFederal ShippingBrazil877
Dairy ProductsFederal ShippingIreland1535
Dairy ProductsSpeedy ExpressUSA2409
Dairy ProductsSpeedy ExpressGermany1200
Dairy ProductsSpeedy ExpressAustria538
Dairy ProductsSpeedy ExpressBrazil640
Dairy ProductsSpeedy ExpressIreland1671
ProduceUnited PackageUSA1912
ProduceUnited PackageGermany774
ProduceUnited PackageAustria549
ProduceUnited PackageBrazil948
ProduceUnited PackageIreland796
ProduceFederal ShippingUSA1715
ProduceFederal ShippingGermany741
ProduceFederal ShippingAustria569
ProduceFederal ShippingBrazil463
ProduceFederal ShippingIreland862
ProduceSpeedy ExpressUSA1606
ProduceSpeedy ExpressGermany744
ProduceSpeedy ExpressAustria890
ProduceSpeedy ExpressBrazil665
ProduceSpeedy ExpressIreland421
ConfectionsUnited PackageUSA1405
ConfectionsUnited PackageGermany788
ConfectionsUnited PackageAustria579
ConfectionsUnited PackageBrazil579
ConfectionsUnited PackageIreland687
ConfectionsFederal ShippingUSA1632
ConfectionsFederal ShippingGermany507
ConfectionsFederal ShippingAustria708
ConfectionsFederal ShippingBrazil729
ConfectionsFederal ShippingIreland493
ConfectionsSpeedy ExpressUSA1652
ConfectionsSpeedy ExpressGermany783
ConfectionsSpeedy ExpressAustria403
ConfectionsSpeedy ExpressBrazil538
ConfectionsSpeedy ExpressIreland592

You can now put the data in Google Sheets then go to Extensions, find Charts, Graphs & Visualizations by ChartExpo, and click on Open.

Interactive Sankey Diagram

Now click on Add New Chart button.

Interactive Sankey Diagram

You will find Sankey Chart in the list of charts.

Interactive Sankey Diagram

Create Sankey Chart in 6 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Packages.

Step 3: Select the column of Delivery Services.

Step 4: Select the column of Countries.

Step 5: Select the column of Deliveries.

Step 6: Once everything is selected. Click on Create Chart.

Interactive Sankey Diagram
Interactive Sankey Diagram

Your chart will be ready.

Interactive Sankey Diagram

Click here to go directly to properties section.

Let’s Draw 4 Level Sankey Chart in Google Sheets

Prerequisite Understanding

You need 4 columns for creating 4 levels Sankey Chart. First to fourth columns will contain data of node, and fourth column will contain metric for each node.

Prepare data for 4 Level Sankey Chart

Let’s make 4 Level Sankey Chart. For this we will use old example but will add one more column in it.

CompaniesPackagesDelivery ServicesCountriesDeliveries
Kings FisheryBeveragesUnited PackageUSA3881
Kings FisheryBeveragesUnited PackageGermany2673
LuminousBeveragesUnited PackageAustria2670
LuminousBeveragesUnited PackageBrazil1424
CVSBeveragesUnited PackageIreland1530
Kings FisheryBeveragesFederal ShippingUSA4266
LuminousBeveragesFederal ShippingGermany1684
LuminousBeveragesFederal ShippingAustria1546
CVSBeveragesFederal ShippingBrazil1736
CVSBeveragesFederal ShippingIreland2930
Kings FisheryBeveragesSpeedy ExpressUSA2997
LuminousBeveragesSpeedy ExpressGermany1572
LuminousBeveragesSpeedy ExpressAustria2255
CVSBeveragesSpeedy ExpressBrazil1223
CVSBeveragesSpeedy ExpressIreland1757
Kings FisheryMeat/PoultryUnited PackageUSA2446
LuminousMeat/PoultryUnited PackageGermany1719
LuminousMeat/PoultryUnited PackageAustria2217
LuminousMeat/PoultryUnited PackageBrazil2633
CVSMeat/PoultryUnited PackageIreland1738
Kings FisheryMeat/PoultryFederal ShippingUSA2733
Kings FisheryMeat/PoultryFederal ShippingGermany1669
Kings FisheryMeat/PoultryFederal ShippingAustria1855
LuminousMeat/PoultryFederal ShippingBrazil1497
CVSMeat/PoultryFederal ShippingIreland1638
Kings FisheryMeat/PoultrySpeedy ExpressUSA2675
LuminousMeat/PoultrySpeedy ExpressGermany2239
CVSMeat/PoultrySpeedy ExpressAustria1801
CVSMeat/PoultrySpeedy ExpressBrazil1749
CVSMeat/PoultrySpeedy ExpressIreland996
Kings FisheryDairy ProductsUnited PackageUSA2314
Kings FisheryDairy ProductsUnited PackageGermany722
LuminousDairy ProductsUnited PackageAustria1866
LuminousDairy ProductsUnited PackageBrazil1947
CVSDairy ProductsUnited PackageIreland1661
Kings FisheryDairy ProductsFederal ShippingUSA2835
LuminousDairy ProductsFederal ShippingGermany624
LuminousDairy ProductsFederal ShippingAustria1473
CVSDairy ProductsFederal ShippingBrazil877
CVSDairy ProductsFederal ShippingIreland1535
Kings FisheryDairy ProductsSpeedy ExpressUSA2409
LuminousDairy ProductsSpeedy ExpressGermany1200
LuminousDairy ProductsSpeedy ExpressAustria538
CVSDairy ProductsSpeedy ExpressBrazil640
CVSDairy ProductsSpeedy ExpressIreland1671
Kings FisheryProduceUnited PackageUSA1912
LuminousProduceUnited PackageGermany774
LuminousProduceUnited PackageAustria549
LuminousProduceUnited PackageBrazil948
CVSProduceUnited PackageIreland796
Kings FisheryProduceFederal ShippingUSA1715
Kings FisheryProduceFederal ShippingGermany741
Kings FisheryProduceFederal ShippingAustria569
LuminousProduceFederal ShippingBrazil463
CVSProduceFederal ShippingIreland862
Kings FisheryProduceSpeedy ExpressUSA1606
Kings FisheryProduceSpeedy ExpressGermany744
LuminousProduceSpeedy ExpressAustria890
LuminousProduceSpeedy ExpressBrazil665
CVSProduceSpeedy ExpressIreland421
Kings FisheryConfectionsUnited PackageUSA1405
LuminousConfectionsUnited PackageGermany788
LuminousConfectionsUnited PackageAustria579
CVSConfectionsUnited PackageBrazil579
CVSConfectionsUnited PackageIreland687
Kings FisheryConfectionsFederal ShippingUSA1632
LuminousConfectionsFederal ShippingGermany507
LuminousConfectionsFederal ShippingAustria708
CVSConfectionsFederal ShippingBrazil729
CVSConfectionsFederal ShippingIreland493
Kings FisheryConfectionsSpeedy ExpressUSA1652
LuminousConfectionsSpeedy ExpressGermany783
LuminousConfectionsSpeedy ExpressAustria403
LuminousConfectionsSpeedy ExpressBrazil538
CVSConfectionsSpeedy ExpressIreland592

You can now put the data in Google Sheets then go to Extensions, find Charts, Graphs & Visualizations by ChartExpo, and click on Open.

Interactive Sankey Diagram

Now click on Add New Chart button.

Interactive Sankey Diagram

You will find Sankey Chart in the list of charts.

Interactive Sankey Diagram

Create Sankey Chart in 7 simple steps

Step 1: Select relevant sheet name.

Step 2: Select the column of Companies.

Step 3: Select the column of Packages.

Step 4: Select the column of Delivery Services.

Step 5: Select the column of Countries.

Step 6: Select the column of Deliveries.

Step 7: Click on Create Chart after selecting all columns.

Interactive Sankey Diagram
Interactive Sankey Diagram

Your chart is ready to be serve.

Interactive Sankey Diagram

Understand Different Properties for Sankey Chart

Following properties you should know to bring more improvement in Sankey Chart presentation.

1. How to sort nodes and levels in Sankey Chart?

Let’s arrange nodes in whole Sankey chart. Click on highlighted icon in Sankey chart.

Interactive Sankey Diagram

A new window will appear. Click on Chart.

Interactive Sankey Diagram

If you select By metric (Deliveries) ASC it will arrange nodes in ascending order according to value of Deliveries, By metric (Deliveries) DESC it will arrange nodes in descending order according to value of Deliveries, by number of links ASC will sort nodes ascending order according to number of links each node have, and by number of links DESC will sort nodes descending order according to number of links each node have. Let’s select By metric (Deliveries) DESC.

Note: Changes will be applied on all nodes of chart.

Interactive Sankey Diagram

As shown in figure below all nodes of chart are arrange in descending order.

Interactive Sankey Diagram

Let’s arrange nodes of Level 2 in Sankey Chart. Click on highlighted icon.

Interactive Sankey Diagram

Let’s select By metric (Deliveries) ASC.

Interactive Sankey Diagram

Level 2 nodes are arranged in ascending order.

Interactive Sankey Diagram

2. How to add heading and levels name on Chart?

You can to add heading by going on Edit Chart.

Interactive Sankey Diagram

Click on Chart Header pencil icon (Highlighted with arrow).

Interactive Sankey Diagram
  • Now, a new window will open and go to the Text.
  • Write text in Line 1.
  • After that he have to click on Show.
Interactive Sankey Diagram
  • Here you can apply font styles on your header as per your requirement.
Interactive Sankey Diagram
  • Here we will just change the size of font to 20. If you are done with your changes of font click on Apply.
Interactive Sankey Diagram
  • Our header is added.
Interactive Sankey Diagram

3. How to add levels name on Chart?

You can add level name by going to pencil icon in the bottom.

Interactive Sankey Diagram

New window through this window you can add level name. Here we are adding Companies for level 1. Once done click on apply.

Interactive Sankey Diagram

You can add each level name by doing the same.

Interactive Sankey Diagram

4. Exploring Node Properties

Click on pencil icon on the top of Kings Fishery.

Interactive Sankey Diagram

First property in this new window is Node.

Interactive Sankey Diagram

From Mark as Drop-Off Node property you can disable/enable a node. Enable it and click on Apply.

Interactive Sankey Diagram

The Kings Fishery node is disable now.

Interactive Sankey Diagram

Now, let’s reset to see more properties. Click on pencil icon on the top Kings Fishery. Go to “Reset” button against Node.

Interactive Sankey Diagram

Click on Yes button.

Interactive Sankey Diagram

Press Apply button.

Interactive Sankey Diagram

Kings Fishery node enabled.

Note: Rest button resets the current property to default properties.

Interactive Sankey Diagram

Click on pencil icon on the top of Kings Fishery.

Interactive Sankey Diagram

First property in this new window is Node. You can use this for changing the color of current node.

Interactive Sankey Diagram

After selecting “All” go to apply.

Interactive Sankey Diagram

You can select as per requirement, after that click on Choose.

Interactive Sankey Diagram

With Color Direction properties you can decide in which direction flow colors should be applied.

Interactive Sankey Diagram

When you click on “All” a drop will open. “All” will apply red color to every level nodes. Let’s apply this.

Interactive Sankey Diagram

After selecting “All” go to apply.

Interactive Sankey Diagram

You can see that Kings Fishery red color flow is applied to the end of chart.

Interactive Sankey Diagram

Now, let’s choose None for next case study. First click on Kings Fishery top pencil icon, go to Node and choose None in from Color Direction drop down.

Interactive Sankey Diagram

After choosing None click on Apply.

Interactive Sankey Diagram

Now, red color is only applied on node.

Interactive Sankey Diagram

Let’s explore other options on United Package node. Click on United Package top pencil icon, go to Node.

Interactive Sankey Diagram

Pick color of your choice.

Interactive Sankey Diagram

Choose Node Links Left in from Color Direction drop down.

Interactive Sankey Diagram

After selecting Node Links Left. Click on Apply button.

Interactive Sankey Diagram

Blue color is on left flow of United Package.

Interactive Sankey Diagram

Let’s try Node Links Right on United Package node. Click on United Package top pencil icon, go to Node. Choose Node Links Right in from Color Direction drop down.

Interactive Sankey Diagram

After selecting Node Links Right. Click on Apply button.

Interactive Sankey Diagram

Blue color is on right flow of United Package.

Interactive Sankey Diagram

Let’s use Node Link Left One Level on United Package node. Click on United Package top pencil icon, go to Node. Choose Node Links Left One Level in from Color Direction drop down.

Interactive Sankey Diagram

After selecting Node Links Left One Level. Click on Apply button.

Interactive Sankey Diagram

Blue color is applied one level left flow of United Package.

Interactive Sankey Diagram

Let’s use Node Links Right One Level on United Package node. Click on United Package top pencil icon, go to Node. Choose Node Links One Left One Level in from Color Direction drop down.

Interactive Sankey Diagram

After selecting Node Links One Left One Level. Click on Apply button.

Interactive Sankey Diagram

Blue color is applied one level right flow of United Package.

Interactive Sankey Diagram

Let’s explore second item in list of Node Properties. Which is Link.

Interactive Sankey Diagram

When click on Link it will expand. Under Link Show zero value is first property and it can hide/show the flow which have zero value.

Interactive Sankey Diagram

Second property under Link is Opacity. You increase or decrease the value opacity of link (flow).

Interactive Sankey Diagram

Let’s set Opacity value on 0.7 and click on Apply button.

Interactive Sankey Diagram

As you can see the opacity of flow has increased.

Interactive Sankey Diagram

Let’s explore Number in list of Node Properties.

Interactive Sankey Diagram

When click on Number it will expand. Under Number you will find Show Number and it can hide/show the number (stats).

Interactive Sankey Diagram

Second property under Number is Scope. With this you can define either you want to apply this change to whole chart or just on current node level.

Interactive Sankey Diagram

Let’s hide numbers of Delivery Services. After selecting Level click on Apply button.

Interactive Sankey Diagram

As you can notice Numbers for Delivery Services are not showing. You can hide/show numbers in whole chart by selecting Chart in Scope drop down.

Interactive Sankey Diagram

Let’s Percentage in Node Properties menu.

Interactive Sankey Diagram

When click on Percentage it will expand. Under Percentage you will find Show Percentage and it can hide/show the Percentage.

Interactive Sankey Diagram

Second property under Number is Scope. With this you can define either you want to apply this change to whole chart or just on current node level.

Interactive Sankey Diagram

Let’s hide Percentage of whole chart. After selecting Chart click on Apply button.

Interactive Sankey Diagram

As you can notice Numbers for Delivery Services are not showing. You can hide/show numbers in whole chart by selecting Chart in Scope drop down.

Interactive Sankey Diagram

In Percentage section third property is about Precision. You can change it to any value you want to have for precision (how many numeric to show after decimal).

Interactive Sankey Diagram

Now, let’s explore currency symbols as prefix or postfix in Node Properties.

Interactive Sankey Diagram

Under Symbols you will find Prefix and Postfix options. With this you can add Prefix/Postfix against value. Let’s add Prefix of $ against value.

Interactive Sankey Diagram

As you can notice Prefix $ added against each node value.

Interactive Sankey Diagram

Next item in Node Properties is Font Styles.

Interactive Sankey Diagram

First property is Chart.

Interactive Sankey Diagram

When expand this you will find following three options.

  1. Chart
  2. Level
  3. Node
Interactive Sankey Diagram

If you choose Chart the changes in font styles will be applied in chart. If you choose Level the changes in font styles will be applied on current level. If you choose Node the changes in font styles will be applied on current node.

Interactive Sankey Diagram

Let’s apply font style changes on Node. For this let’s increase the size of font and bold the font. Previous font is 12.

Interactive Sankey Diagram

Let’s change font size to 14 and click on B to make font bold.

Interactive Sankey Diagram

After applying all changes click on Apply.

Interactive Sankey Diagram

As you can notice Font size of United Package is changed and bold.

Interactive Sankey Diagram

Once you have made changes in properties, you can Click on Save Button to preserve your all new properties, let’s see below how chart will look if you apply certain properties.

Interactive Sankey Diagram

Here is our final visualization with changed properties as they are all preserved now.

Interactive Sankey Diagram

How does Add chart to sheet and Export works?

If click on “Add chart to sheet” button this visualization will appear on your Google Sheets.

Interactive Sankey Diagram

Sankey Chart is added in Google Sheets.

Interactive Sankey Diagram

If you click on Export button.

Interactive Sankey Diagram

It will ask you either you want visualization in JPG or PNG format.

Interactive Sankey Diagram

Let’s choose Export as JPG option.

Interactive Sankey Diagram

It will automatically download on your PC.

Interactive Sankey Diagram

If you slide highlighted dots of width or height to right will increase width or height of chart. The maximum width goes up to 1200px and minimum width goes up to 100. The maximum height goes up to 750px and minimum height goes up to 333.

Interactive Sankey Diagram

If you slide highlighted dots of width or height to right will increase width or height of chart. The maximum width goes up to 1200px and minimum width goes up to 100. The maximum height goes up to 750px and minimum height goes up to 333.

Interactive Sankey Diagram

How does Reset all button work?

If you click on Reset all button all setting wipe out and visualization will go to default Sankey Chart.

Interactive Sankey Diagram

A new window will appear click on Yes.

Interactive Sankey Diagram

A new window will appear click on Yes.

Interactive Sankey Diagram

After this you will have default Sankey Chart.
You can create Sankey Chart much effort with ChartExpo. Sankey Chart can be created any type of flow data by following these steps.

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
120728

Related articles

next previous
Data Visualization11 min read

How to Craft Engaging Google Forms Questions?

Click to learn how to craft engaging Google Forms questions. Also, we’ll show how to analyze Google Forms questions.

Data Visualization11 min read

How to Craft Engaging & Compelling Google Docs Questionnaires?

Click to learn how to craft engaging Google Docs questionnaires. Also, we’ll show you tips for effective questionnaire design.

Data Visualization11 min read

How Do Google Forms Work: A Step-by-Step Guide

Click to learn the following: how does Google Forms work? Also, we’ll show you tips for using Google Forms effectively.

Data Visualization8 min read

How to Build an Effective Customer Feedback Loop?

Click to learn how to build an effective customer feedback loop. Also, we’ll show you how to analyze customer feedback loop data.

Data Visualization9 min read

How are Surveys Conducted? Easy Steps to Follow

Click to learn the answer: “How are surveys conducted?” Also, you’ll learn how to analyze survey results.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2023 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers