Forum Discussion

stpstein's avatar
stpstein
Copper Contributor
Dec 02, 2019
Solved

Help with Gantt chart

Hi,   I'm not understanding what I'm doing wrong and why my Gantt isn't showing my data correctly. this is how I did it last time but now suddenly the data is showing all wrong. my sheet is attache...
excel
Excel on Mac
  • Tanya Denton's avatar
    Tanya Denton
    Dec 02, 2019

    stpstein I think you need to change the chart to a 'Stacked Bar' chart.  Then under select data, switch the Start Date and Duration order (making the Start Date first), then the chart will show two colours.    Mine showed Orange and Blue -set the blue to No Fill.  This worked for me - attached 

Tanya Denton's avatar
Tanya Denton
Steel Contributor
Dec 02, 2019

stpstein I think you need to change the chart to a 'Stacked Bar' chart.  Then under select data, switch the Start Date and Duration order (making the Start Date first), then the chart will show two colours.    Mine showed Orange and Blue -set the blue to No Fill.  This worked for me - attached 

  • stpstein's avatar
    stpstein
    Copper Contributor
    Dec 02, 2019

    Hi Tanya,

    Thanks, it was actually very silly of me, I simply didn't notice I didn't choose a stacked bar chart!

     

    Thank you!!!