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.

Creating a Gantt chart to show Baseline and Current Plan data.

Discussion in 'Discuss Data Visualizations and Charting' started by Pete Mccann, Jan 21, 2018.

  1. Pete Mccann

    Pete Mccann Member

    Messages:
    84
    Dear all, further to the "Stacked column Chart" answer https://chandoo.org/forum/threads/stacked-column-chart.36977/ from p45cal, I have been trying to do something similar for a Gantt chart to show a simplified comparison between a baseline Plan of Work and the Current (latest) plan of work (attached).

    I have plotted the “Baseline information” on the Primary vertical Axis and the “Current information” on the secondary Axis. I'm not sure if this is the right way of plotting this sort of data. I’ve nearly got it to work but it doesn’t seem to be quite right (the red and blue bars don't overlay or display as they should). Can anyone see where I'm going wrong? In this example, there is no "current" data available for the yellow highlighted cells to compare with the "baseline".

    Attached Files:

  2. Pete Mccann

    Pete Mccann Member

    Messages:
    84
    Many apologies. I had intended to post this in the data visualizations and charting forum.
  3. vletm

    vletm Excel Ninja

    Messages:
    4,135

    Attached Files:

    Thomas Kuriakose likes this.
  4. Pete Mccann

    Pete Mccann Member

    Messages:
    84
    Thanks vletm. That is perfect. Can you tell me what I was doing wrong...:)?
  5. vletm

    vletm Excel Ninja

    Messages:
    4,135
    Pete Mccann
    Wrong? ... hmm?
    Who else than You could say that there were something 'wrong'?
    It all depends, what do You want to show?
    You would compare 'Your' and 'my' versions... and find difference?
  6. Pete Mccann

    Pete Mccann Member

    Messages:
    84
    Ha ha. Thanks - I will compare the two versions and see if I can understand why your version works and my version doesn't. Best regards.

Share This Page