Forum Discussion

SankeyUser's avatar
SankeyUser
New Member
7 years ago

Sankey diagram question

Hi All and happy new year.   I am new to Sankey diagram and I need some help. I need to present product reconcilliation with each stage of manufacturing (inputs and outputs). Specifically, there a...
Need Help
SankeyUser's avatar
SankeyUser
New Member
7 years ago

Hi Cherie,

 

Thank you so much. the sample file was very helpful. I will try it on my exaple and will see how it goes.

 

Regards,

SankeyUser's avatar
SankeyUser
New Member
7 years ago

So I tried to follow the sample file and this is what I got.

 

I am not sure if this is clear but this represents different stages of manufacturing, where in every srage, there is waste and samples. Ultimately, the accountabilty should be 100% (my good product, plus waste plus samples). Here are 3 things I need help with:

1. How can I make the components of each stage appear consistently? for example, product, samples, and waste. I arragned the data in this this order but the driagram mixed up the order.

2. Why the lines are crossed? How can I make them parallel or at least not crossed.

3. How can I show the break up date for each stage? for example, the amount of product, samples and waste.

 

I dont know if I can  attach a file but here is my data

 

 

Lot 1Granulation2192.48
Lot 1Samples0
Lot 1Waste33.52
Lot 2Granulation2176.18
Lot 2Samples0
Lot 2Waste49.82
Lot 3Granulation2183.84
Lot 3Samples0
Lot 3Waste42.16
Lot 4Granulation2176.25
Lot 4Samples0
Lot 4Waste49.75
Lot 5Granulation2204.88
Lot 5Samples0
Lot 5Waste21.12
Lot 6Granulation2194.41
Lot 6Samples0
Lot 6Waste31.59
GranulationBlend14168
GranulationBlend Samples236
GranulationBlend Waste262
BlendCompressed Tablets13060
BlendCompression Samples118
BlendCompression Waste1252
Compressed Tablets90's Mono3500
Compressed Tablets90's Multi3540
Compressed Tablets1000's6500
90's Mono90's Mono bottles2056
90's Mono90's Mono Samples177
90's Mono90's Mono Stability Samples1097
90's Mono90's Mono Micro Samples47
90's Mono90's Mono Waste0
90's Multi90's multi bottles2207
90's Multi90's Multi Samples177
90's Multi90's Multi Stability Samples1097
90's Multi90's Multi Micro Samples59
90's Multi90's Multi Waste0
1000's1000's bottles1835
1000's1000's Samples393
1000's1000's Stability Samples3670
1000's1000's Waste0

 

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi SankeyUser

     

    It seems they should be crossed because the Sources Lot1,Lot2...Lot6 have the same destinations(Samples,Waste,Granulation). If you want to change the order, you may try to click on the chart to move it manually.Turn on the 'Data link labels' could show the values. 

     

    Regards,

    Cherie