1 2 Previous Next 20 Replies Latest reply on Mar 23, 2018 2:22 AM by Dave Rawlings Go to original post
• ###### 15. Re: Regd. Sankey Chart

I couldn't find any difference between this and your method except the orientation because the rows and columns are swapped.

1 interesting thing I noticed when I viewed the data is that in our case, the sales value is present in all rows, while in this case it is present only when Padded is 1 or 49, but it is missing for all values from 2 to 48. I don't know if this is the reason it is converging, also if it is then how do I make it happen in practice?

Another possibility is the sheer number of data points is making the points converge, but I'm not sure.

• ###### 16. Re: Regd. Sankey Chart

Know, I know where to find Ann's workbook - I meant where is yours? But don't worry I can just explain.

To set the items in the centre then you're not looking to rank each inidividually, just count them together so set Rank 1 to INDEX()/SIZE()

1 of 1 people found this helpful
• ###### 17. Re: Regd. Sankey Chart

Hi Chris, setting Rank 1 to INDEX()/SIZE() makes all the bands on the left the same size, it is not making them converge.

Please find below my workbook and screenshots with 2 different values for Rank 1 - one with the original formula, the other with INDEX()/SIZE()

• ###### 18. Re: Regd. Sankey Chart

Figured it out.

Computation of curve needs to be "Dimension 1 > Padded > Dimension 2" instead of "Dimension 1 > Dimension 2 > Padded"

Thanks for your help Chris, really appreciate it!

1 of 1 people found this helpful
• ###### 19. Re: Regd. Sankey Chart

Great - glad you got it sorted.

• ###### 20. Re: Regd. Sankey Chart

Hi,

Sorry to hijack

I’ve tried to create the simple sankey and it all looked fine apart from the range of the curve axis. Rather than fitting in 0 to 1 mine runs to 2.4? Any idea why that might be?

And if I reverse the axis I can’t get the left, right and chart to align.

Thanks

1 2 Previous Next