SOLVED

Resource tracking within chart

%3CLINGO-SUB%20id%3D%22lingo-sub-3069076%22%20slang%3D%22en-US%22%3EResource%20tracking%20within%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20merge%20the%202%20dates%20of%20the%20same%20resource%20into%20one%20axis%20(one%20row)%20and%20not%202%20separate%20rows%20on%20the%20graph%3F%20At%20the%20moment%20my%20view%20is%20as%20follows%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Zahav2335_0-1642853291877.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341638i163839A187AABC6D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Zahav2335_0-1642853291877.png%22%20alt%3D%22Zahav2335_0-1642853291877.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20be%20presented%20to%20me%20in%20one%20axis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3069076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3069253%22%20slang%3D%22en-US%22%3ERe%3A%20Resource%20tracking%20within%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3069253%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1270112%22%20target%3D%22_blank%22%3E%40Zahav2335%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20put%20the%20durations%2C%20and%20the%20time%20between%2C%20on%20top%20of%20each%20other%20(stacked%20bars)%20and%20set%20the%20blocks%20you%20want%20hidden%20without%20Fill%20Color.%3C%2FP%3E%3CP%3EBelow%20with%20and%20without%20colors%20changed.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22bosinander_0-1642878033669.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F341677iBA56AAC617F3EF9A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22bosinander_0-1642878033669.png%22%20alt%3D%22bosinander_0-1642878033669.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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:

Zahav2335_0-1642853291877.png

 

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

 

Thanks.

7 Replies
best response confirmed by Zahav2335 (Occasional Contributor)
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.

bosinander_0-1642878033669.png

 

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

You're welcome
Hi,

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

Thanks

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

bosinander_2-1645044381734.png

 

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

bosinander_1-1645044155136.png

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

Thanks again