Skip to main content

Data Flow Chart

Garden City Consultants
A tool in Excel to visualize composition and data flow data.

Data Flow Chart is often used to visualize energy flow. I think it is a very good tool to visualize the composition, such as budget, portfolio allocation, etc. Especially, Data Flow Chart can present the legends in multiple levels. It makes it an ideal tool to visualize multiple levels of composition in a unique way that cannot be achieved in other charts.

Data Flow Chart Excel add-in is a tool in Excel to draw the chart based on the data entered by the user in the spreadsheet easily.

In order to demonstrate the usage of Data Flow chart, there are 4 types of sample data are provided in this add-in:

- Simple Budget sample data. This sample provides one level of simple budget data. You can build multiple levels, periods of budget data and draw the Data Flow Chart.

- State Exporters to G20 countries sample. This data comes from US. Bureau of the Census (Release:Number of Exporters and Known Value for All Countries on a State-by-State Basis).

- Portfolio Allocation Style 1 Sample

- Portfolio Allocation Style 2 Sample

These 2 samples actually have the same data. By changing the order of the legends, the data can be presented in different ways.

This add-in is easy to use that it allows user to use sample data template to build his own chart by pasting the data into the sample data table. No special set up is needed. Just grouping the data into 3 columns. The first and second columns are the legends labels you want to show in the chart, the 3rd column is the data. The legends have certain parent/child relationship that you can get from the samples. A tutorial will be provided in the support page.

Add-in capabilities
When this add-in is used, it
  • Can read and make changes to your document
  • Can send data over the Internet
  • https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679860/Asset_0e5288f4-248c-4d1a-9195-6c56c176fa98/SankeyChart1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679860/Asset_0e5288f4-248c-4d1a-9195-6c56c176fa98/SankeyChart1.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679860/Asset_5d616092-687b-4e7c-b779-37f5719fa87c/SankeyChart2.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679860/Asset_e42e1e9f-746d-4926-a9a8-2e4a1ccc2b83/SankeyChart3.png
    https://az158878.vo.msecnd.net/marketing/Partner_21474846017/Product_42949679860/Asset_f27605e2-79f8-400a-94d8-7270b65421d3/SankeyChart4.png