Thursday, 15 May 2014

How to Create A Dual Axis Gantt Chart

I got asked recently if I could help with some data in a gantt chart. Gantt charts are a great way to visual the timeline of a project allowing you to see the duration of separate tasks within a project. The problem they were having was this :


I’ve thrown together a Gantt chart and I want to add a “peak” portion in the middle of each bar.  So each bar represents a project…  let’s say for example Project A lasts from 4/1/14 through 4/15/14.  Well I want that bar to be a light color, aside from the “peak” portion that’s a shade darker… let’s say 4/7/14 through 4/9/14.  So each bar would show the entire time that the project is “active” but it will also show where a team member is busiest with that project.  
This is what the original looked like 



The data included the project start and end dates along with a peak start and end date. These dates were used to create two calculated fields for Project Duration and Peak Duration.

My initial thought was could you create a dual axis gantt chart and overlay the peak durations over the top of the project durations already on the chart. 

First right drag the Peak begin date to the column shelf and select the continuous day. 
Next select dual axis and then synchronise the axis so that the two sets of marks overlap each other. 

At the moment the peak gantt chart is using the project duration as the length of the bars so drag the peak duration measure onto the size shelf of the Peak Begin chart. 



Finally change the transparency of the colours of the project gantt so that they are a lighter shade 


And now your chart should look something like this



So now you are able to clearly see the duration of each of the projects and when the peak activity occurred within each one. I've already come up with a couple of uses for this in my day job, hopefully this little tutorial will be of use to you too. 







Matt Francis

Author & Editor

Tableau Zen Master, Social Ambassador, Wrangler of Data, Vizzer of Data

4 comments :

  1. Tableau online training| Tableau training| call us+ ...
    www.21cssindia.com/courses/tableau-online-training-226.html
    tableau online training, tableau training, tableau course contents, tableau, tableau enquiry, tableau training institute india, andhra pradesh, visakhapatnam, call ... Call Us +919000444287 or contact@21cssindia.com

    ReplyDelete
  2. Is there a gantt chart software to be used for creating amazing gantt charts likes these. I'm been searching for one online.

    ReplyDelete
  3. Hello
    Can you please share the excel data file for this Gantt chart

    Thx

    ReplyDelete

 
biz.