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.

Gantt visualisation challenge

Discussion in 'Discuss Data Visualizations and Charting' started by torben, Apr 13, 2018.

  1. torben

    torben New Member

    Messages:
    10
    upload_2018-4-13_11-21-43.png

    Hi,
    Can any of you brilliant people help me to establish this kind of layout for a gannt chart?
    I would love to see the chart with a dynamic scroll on the time scale. The lines and milestones should be formatted depending on status markers in the data.
    Many thanks!
    Torben upload_2018-4-13_11-21-43.png
  2. vletm

    vletm Excel Ninja

    Messages:
    4,312
    torben
    Do You have data for that Gannt-chart?
    Without as realistic data as You would like to use ...
    Your data seems to have over one year dates or what would be those Q1..Q4.
    ... few kind of markers ...
    What else there would be?
    ... or You would have a new challenge!
  3. torben

    torben New Member

    Messages:
    10
    Just some very basic lines attached here. And yes, the dates will span over years, but could be monitored in periods of choice. I illustrated it with a quarterly review.
    Round markers are milestones approved, declined, or in progress. I am not yet sure of the need for formatting the lines, but it would be nice to have the option.

    Attached Files:

  4. vletm

    vletm Excel Ninja

    Messages:
    4,312
    torben
    Check Sheet3 and
    modify Your data as it would be shown with Your 'challenge'.
    If some values would be as approved and so on ...
    then where were those in data?
    There is huge difference with terms 'need' and 'nice to have'(=no need).
    You should have clear vision ... what would You need?

    Attached Files:

  5. torben

    torben New Member

    Messages:
    10
    The data sheet should now reflect the gannt. Start and end come from the dates, and any milestones are also activated if there is a date input. Each gate can then be either pending, approved or rejected. Hope this makes everything clear :)

    Attached Files:

  6. vletm

    vletm Excel Ninja

    Messages:
    4,312
    torben - The data sheet should now reflect the gannt.
    Did You mean Your data sheet's data or what?
    Hint: It would be better to keep those dates NOW in the same sheet, that You could notice ... something!
    Four gate's dates would see by 'line' (... and dates ... really means dates!).
    Your 'data' has also two kind of GN statues with text
    ... I didn't start to guess ... four gates.

    Hope ... hmm ... I miss that sentence. I missed term 'focus'.

    Attached Files:

  7. torben

    torben New Member

    Messages:
    10
    vletm,
    I am not quite sure what the problem is? I need a gannt layout as illustrated.
    I need your help to suggest if/how it can be done.
    What data is needed, how should it be organized, etc. should be part of the response.
  8. vletm

    vletm Excel Ninja

    Messages:
    4,312
    torben
    #2 Reply - I asked 'Do You have data for that Gannt-chart?'
    #5 Reply - You sent 'data' which did not reflect Your illustrated.
    Did You check my previous file?
    There are some similarity with Your illustrated ... or how?
    There are also some notes/hints.
    ... and now You ask: what data is needed? ... hmm?
    You would get correct data somewhere.
    Many things depends of that data!
    After that,
    it's possible to figure how to get illustrated output from it
    ... or as close output as possible.
    Someone have to have clear image/vision to give with needed data.
  9. torben

    torben New Member

    Messages:
    10
    Thanks, your idea of using a scatter chart solves the layout to some extent. Would it also be possible to format the milestones depending on the status? (cells N17-Q17 in your sheet)
  10. vletm

    vletm Excel Ninja

    Messages:
    4,312
    torben
    Many things would be possible if You would even try...
    and give answers.

    Attached Files:

  11. torben

    torben New Member

    Messages:
    10
    Thx - there seems to be a problem though. I cannot add or edit the series. See attached 2018-04-17_09-42-52.jpg
  12. vletm

    vletm Excel Ninja

    Messages:
    4,312
    There are no problems ... only challenges,
    and those would be because, if You cannot figure logic.
    You have to t-h-i-n-k and s-t-u-d-y, how do those would work
    ... not 'just write something somewhere'.
    > You can edit & add those.
    > Editing series would be quicker.
    > Adding series ... hmm ... would need more than one second.
    I have tried to ask realistic data ... but no!
    Then I gotta do 'my data'.
    To that active cell, You should write date eg 17/04/2018!
  13. torben

    torben New Member

    Messages:
    10
    Thx - but this conversation stops here.
    If my questions are so insulting, why do you bother replying?
  14. vletm

    vletm Excel Ninja

    Messages:
    4,312
    As written above:
    To that active cell, You should write date eg 17/04/2018!
  15. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    456
    @torben You might like to have a look at Craig Hatmaker's site for ideas
    https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts
    Craig is of the mindset to contribute to the community so would be supportive. Quite a while ago, I set out by placing shapes representing activities within a chart as the parent object. This allowed me to exploit the time axis and had greater potential for interactivity since Charts support mouse move event handling. Without downloading one of Craig's workbooks, I am not sure what he went with finally.
    Even examining the code would provide something of an eye opener in any case.

Share This Page