Resource tracking within chart

[Zahav2335]

Hi,

How can I merge the 2 dates of the same resource into one axis (one row) and not 2 separate rows on the graph? At the moment my view is as follows:

I want it to be presented to me in one axis.

Thanks.

[#2 · Accepted solution]

Hi @Zahav2335 

You may put the durations, and the time between, on top of each other (stacked bars) and set the blocks you want hidden without Fill Color.

Below with and without colors changed.

[#3]

Thank you very much for your input. it is very helpful.@bosinander 

[#4]

You're welcome :)

[#5]

Hi,

Can I do this when I have multiple data, I mean many resources ?
I tried to do it but did not succeed.

Thanks

[#6]

Yes, you have to extend the data area for the appended resources.

Each new column, next will be E15, makes a new layer in the chart.

The calculations are in the attached file still manually inserted into C16:D19 in the same way as B16:B19.

[#7]

Thanks again :)

[#8]

:)