• 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...

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

Recent content by torben

  1. T

    Gantt visualisation challenge

    Thx - but this conversation stops here. If my questions are so insulting, why do you bother replying?
  2. T

    Gantt visualisation challenge

    Thx - there seems to be a problem though. I cannot add or edit the series. See attached
  3. T

    Gantt visualisation challenge

    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)
  4. T

    Gantt visualisation challenge

    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.
  5. T

    Gantt visualisation challenge

    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 :-)
  6. T

    Gantt visualisation challenge

    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...
  7. T

    Gantt visualisation challenge

    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
  8. T

    A challenge to you clever guys :-) A simple chart to monitor racing time

    4 boats are racing on 9 different lanes with different lenghts. For each lane every boat has a specific theoretic racing time depending on 3 different wind forces. I would like to create a simple dashboard showing how the boats should perform. Boats Lane No. Lane length Lane Type Wind force...
  9. T

    conditional format of cell based on look up

    Great! Thanks very much for the swift response!
  10. T

    conditional format of cell based on look up

    I would like to format a cell colour based on the value from a combobox. Imagine a drop-down list with colour codes and cells adapting to your choice of colour. Is that possible without scripts? Many thanks!
Top