sankey diagrams from excel

[Ramesh Rajagopalan]

First -- the sankey diagram from excel is excellent and thanks.  For a person who is not a techie I got it to work.  But I am having difficulty in rendering it and need some advice and help.  My data has 220 nodes on the right and 22 nodes on the left.  By blindly playing I was able to change the chart dimensions and space the nodes so that they are readable.  But in the process the edges became very thin and light -- I need to know how to increase the edge size so that its more visible.  I tried the vale column and even if I increase it a lot the edges are thin.  second I am unable to get the vertical boxes at the nodes -should I increase the node width and/or height ?  any advice would be helpful.  Thanks

[Bruce McPherson]

Send me your workbook

Bruce

Sent from my iPad

On 7 Aug 2013, at 22:43, Ramesh Rajagopalan <mailram...@gmail.com> wrote:

First -- the sankey diagram from excel is excellent and thanks.  For a person who is not a techie I got it to work.  But I am having difficulty in rendering it and need some advice and help.  My data has 220 nodes on the right and 22 nodes on the left.  By blindly playing I was able to change the chart dimensions and space the nodes so that they are readable.  But in the process the edges became very thin and light -- I need to know how to increase the edge size so that its more visible.  I tried the vale column and even if I increase it a lot the edges are thin.  second I am unable to get the vertical boxes at the nodes -should I increase the node width and/or height ?  any advice would be helpful.  Thanks

--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Ramesh Rajagopalan]

Thanks Bruce.  I couldn't send the file - gmail thinks there is virus so wont allow me to send it.  I copied the sankey tab and its attached. I am also attaching a power point which has some visualizations which is what I am shooting for.  I have a plotter so I want to be able to print it big size.

--
You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/r0IZUsfTBFI/unsubscribe.
To unsubscribe from this group and all of its topics, send an email to excel-ramblin...@googlegroups.com.

[Bruce McPherson]

Delete the gistthat module. It is used for automatic updating and can register as a false positive. 

See this note about that

http://jatinpatni.byethost13.com/?x=entry:entry111015-194801

I'll look at your stuff later on

Bruce
Sent from my iPad

<sankey tab.xlsx>

<sankey visualization.pptx>

[Bruce Mcpherson]

Download the latest cdataset.xlsm

You can set the required width and height in the options section of the sankey parameters sheet, Your data is in the tab called bigsankey

[Ramesh Rajagopalan]

Thanks a bunch  Bruce.  I will look at it later today when I get back.  butI really appreciate it,  yesterday night I spent some more time on the site and I am amazed at what all is possible.  Truly liberated !

 

ramesh

[Ramesh Rajagopalan]

Thanks Bruce - worked fine.  One small nit picky thing - not a show stopper.  the labels are inside so gets lost. if we could put it outside it would be more legible. But this is excellent and thanks again.

[Bruce McPherson]

The labels are inside what ?

Bruce

Sent from my iPad

[Ramesh Rajagopalan]

Bruce.  attached is the image and as you can see I retyped the labels for the functions outside in bigger font.  the apps are Ok because there is 200 of them.  by inside I mean inside the graphic.  for print I had to make the edges dark and then it would render the labels less legible.  On the web its no problem as one can zoom and pan etc.

 

Ramesh 

[Bruce Mcpherson]

hmm.. yes it would be possible to do this but it would mean a lot of changes. The diagram would have to shrink to allow room for the text, and it would need to shrink by the longest text that it could find. There's a lot of math that would need tweaking for that. 

I dont have time to do that now, but i'll put it on the list

bruce

[Ramesh Rajagopalan]

Thanks Bruce.  I perfectly understand.