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