1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sunburst alternative

Discussion in 'Discuss Data Visualizations and Charting' started by Starkus, Jun 29, 2018.

  1. Starkus

    Starkus New Member

    Messages:
    8
    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 arranging the data to show it in a sunburst chart. The sunburst shows what I want to see, but because sunbursts are circled, fields appear bigger than they really are. This is confusing.

    Therefore, I am looking for a chart that does the same as a sunburst, only then not circled. I did a lot of researching, but I cannot find a chart type that can do that. In the picture attached you can visually see what I mean.

    Can somebody please help me or give me tips on how to visualize the data otherwise?

    Take care,

    Julian
    [​IMG]
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
  3. Starkus

    Starkus New Member

    Messages:
    8
  4. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    So, upload sample workbook and also draw free hand, how you want the chart to look like. We are not mind reader after all ;)
  5. Starkus

    Starkus New Member

    Messages:
    8
    O I see the link broke... Excuse me for that. Attached you can find the data, and a picture of what I think it should look like.

    Attached Files:

  6. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    Hmm, I don't think that visual/chart is all that useful in telling a story.

    I'd go with linked charts personally. First showing breakdown at highest level.

    Then by either clicking category, shows break down of that category etc.

    What's the purpose of the chart?
  7. Starkus

    Starkus New Member

    Messages:
    8
    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 Machining, and so forth. The white space after a certain operation means that it went to shipping after that (so, no following operation).

    By visualizing our production data this way, we can see what combination of operations are common in our production.
  8. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    Ah, ok. So it's like flow chart with volume associated with it. But with multiple starting point and end point for one, can be start point of another...

    Let me think on that one, nothing immediately comes to mind.
  9. Starkus

    Starkus New Member

    Messages:
    8
    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!
  10. Starkus

    Starkus New Member

    Messages:
    8
    @Chihiro, were you able to come up with anything? I am very curious if there is a solution out there somewhere! :)
  11. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,052
    Not really via Excel. May be using R script, something like Sankey diagram...

    https://www.r-bloggers.com/creating-custom-sankey-diagrams-using-r/
    https://www.r-graph-gallery.com/sankey-diagram/

    Using PowerBI custom visual.
    https://powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-sankey-diagram/

    I haven't tested it myself, but you may find below helpful in drawing Sankey in Excel.

    http://www.doka.ch/sankey.htm

    Other resources on Sankey diagram:
    http://www.sankey-diagrams.com/sankey-diagram-software/
  12. Starkus

    Starkus New Member

    Messages:
    8
    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 data.

    Thanks so much for your help so far!!! I really appreciate it.
  13. Starkus

    Starkus New Member

    Messages:
    8
    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.

Share This Page