e!Sankey-Forum

General Category => General Discussion => Topic started by: pbeilschmidt on June 28, 2018, 03:14 PM

Title: New Videos on e!Sankey Live Link to Excel
Post by: pbeilschmidt on June 28, 2018, 03:14 PM
Two new videos have been uploaded to the e!Sankey You Tube Channel, that might be of interest.

Using e!Sankey Live Links to Microsoft Excel | Part 1 (https://www.youtube.com/watch?v=fpKc5srwieA) (10 mins)
This video shows how to set the Live Link reference and update a Sankey diagram with values from Excel

Using e!Sankey Live Links to Microsoft Excel | Part 2 (https://www.youtube.com/watch?v=WCqaHDYk0cs) (5 mins)
This video explains how the Live Link can be combined with advanced functions in Excel (here: INDIRECT) to switch between datasets (e.g. annual energy data)

Enjoy!
Title: Re: New Videos on e!Sankey Live Link to Excel
Post by: pbeilschmidt on July 30, 2018, 03:00 PM
And two more videos have been added:

e!Sankey 4 | Process properties: shapes, icons, images (https://www.youtube.com/watch?v=9uvk5aEYvWE)  (2 mins)
Learn how to change the default process property symbol in a Sankey diagram. Use different shapes, fill colors, an icon from the clipart gallery or a photo. Quite a funny sample diagram ('Paul's pet costs').

e!Sankey 4 | How to avoid overlapping arrows (https://www.youtube.com/watch?v=JQgkuRO0vF4)  (3 mins)
In this video learn how to avoid overlapping arrows and gaps between arrows running parallely. Sample diagram shows imports and exports to/from the United States broken down in product groups.
Title: Re: New Videos on e!Sankey Live Link to Excel
Post by: Scholten on September 19, 2018, 12:15 PM
Two new videos have been uploaded to the e!Sankey You Tube Channel, that might be of interest.

Will there be more videos like these, Peter? I think they're a great resource.