I would suggest to combine all your status dates into one date field by pivoting the status date columns. Then you can get both open and closed bars side by side on one date axis.
Thanks for this suggestion.
Can you please provide some steps on how I would go about combining the two date fields into one date by pivoting? Do I need to put them both in the Columns section of the worksheet? Not sure how to proceed.
Thanks for any detail you can provide.
Maybe creating a new field with a calculation like this:
IF [Dt Chegada] < [Dt Solicitacao] then [Dt Chegada]
ELSE [Dt Chegada] >= [Dt Solicitacao] then [Dt Solicitacao]
You'll need to check if some date will be lost.