Project Chart

[Roy_Excel_Island_Apps]

Hi everyone!

For project management we would like to create the graph in attachment, depending on the table you'll see in the other attachment image.
It's a kind of a gantt chart about the different people in the organisation on the y-axis and different projects (Awareness, Desire, Knowledge, ...) on the x-axis. To make it 'easy', the Awareness project, the first project, starts today. And it starts for everyone on the same day.
How do I get to build this graph?

Please help us out!

Thanks a 1000 times in advance!

Kind regards,
Roy
Belgium

 

[awoohaw]

your 2nd image is much to small to read.

And can you post your data using the xl2bb add in, or pasting the data as a table instead of an image. By using images the forum must recreate your data which is time consuming and can have errors. Link to xl2bb below.

thanks in advance.

 

[Roy_Excel_Island_Apps]

your 2nd image is much to small to read.

And can you post your data using the xl2bb add in, or pasting the data as a table instead of an image. By using images the forum must recreate your data which is time consuming and can have errors. Link to xl2bb below.

thanks in advance.

Hi! Can't install add-ins on my laptop from work so I'll have to paste the data in a table:

	Awareness		Desire		Knowledge		Ability		Reinforcement
Board	04/01/2024​	10/01/2024​	10/01/2024​	01/02/2024​	1/02/2024​	01/03/2024​	1/03/2024​	01/05/2024​	1/05/2024​	15/05/2024​
Division Manager	04/01/2024​	20/01/2024​	20/01/2024​	01/03/2024​	1/03/2024​	15/03/2024​	15/03/2024​	01/04/2024​	1/04/2024​	01/05/2024​
Cluster Manager	04/01/2024​	13/03/2024​	13/03/2024​	30/03/2024​	30/03/2024​	15/04/2024​	15/04/2024​	01/05/2024​	1/05/2024​	18/05/2024​
Team Manager	04/01/2024​	01/02/2024​	1/02/2024​	01/04/2024​	1/04/2024​	01/05/2024​	1/05/2024​	15/05/2024​	15/05/2024​	01/06/2024​
Co-worker	04/01/2024​	01/05/2024​	1/05/2024​	10/05/2024​	10/05/2024​	20/05/2024​	20/05/2024​	01/06/2024​	1/06/2024​	15/06/2024​

 

[awoohaw]

I understand about the add ins. Thanks for the table. You'll get a response from someone, if not me, much quicker!
A larger screen shot of your desired outcome would also be helpful.

 

[Roy_Excel_Island_Apps]

I understand about the add ins. Thanks for the table. You'll get a response from someone, if not me, much quicker!
A larger screen shot of your desired outcome would also be helpful.

This image is better maybe. But the only difference is that we want the figures to be replaced by dates. It works good with figures, but not with dates.

 

[felixstraube]

Maybe one of these options?

Chart.zip

This first one is a X-Y chart. And the bars you see are the error (only positive one).
You will need a helper table (rows 9 and 10)
For the Board and Division Manager text I added 2 textboxes grouped together.

Then there is simple bar chart:

Where you hide the bottom axis and use 30,4375 (days) in the major units.

Not the best options I think but maybe its a start?

 

[Roy_Excel_Island_Apps]

Maybe one of these options?

Chart.zip

View attachment 104370

This first one is a X-Y chart. And the bars you see are the error (only positive one).
You will need a helper table (rows 9 and 10)
For the Board and Division Manager text I added 2 textboxes grouped together.

Then there is simple bar chart:

View attachment 104371

Where you hide the bottom axis and use 30,4375 (days) in the major units.

Not the best options I think but maybe its a start?

They work both very good! Thank you! God bless you!

 

[felixstraube]

Happy to help. Thanks for the feedback