I found exactly what I was looking for! An Icicle Diagram. It's not possible to make it in Excel. So far it looks like the only way to make it is with D3.js.
Hmm... Sankey diagrams, never thought about that! Looks promising :) I am going to play around with some of the tools you provided.
Please let me know if you ever find something like that diagram that I made in that attached image. I still feel like that would be the best way to present my...
Exactly. And by doing that, it is important that the routes stay connected. Any other type of diagram in Excel disconnects the routes, which makes it not usable. Thanks so much!
It would be very useful if we can show it that way. The purpose of the chart is to show what our main production routes were over the last 2 years.
So for example, we can see that 70% of the total production started in LSRFL. Of the jobs that started in LSRFL, 40% then went to BENDFL, 20% to...
Hi everyone,
I am trying to visualize our production routing date in Excel. I have data that tells every unique routing for a production order (over 70,000 P.O.'s, over the last 2 years), and my goal is to find out what the most common routes are in our production.
I have spent a lot of time...