Bar graph for text values over years

My client wants to chart the various years that missionary organisations maintained certain welfare centres AND, if possible, denote the denomination of that organisation with various colours (see the PDF attached). I'm thinking that Excel might not be the best program to do this with, but thought I would ask in case one of you is inspired! I have tried pivoting data, but the best thing I could come up with was a high/low/close graph which is close, but no medal! Any ideas? Thanks.

Hi Dimonds,

Here is my take on your chart.

I have grouped the data into categories and made it look like a Gantt Chart.

If you like this and want to learn more, here is link to a step-by-step and video tutorials for the topics on how I made these:

This demos the Gantt Chart:
How-to Make a Basic Gantt Chart in an Excel Chart in 7 Easy Steps

This demos the Multi-Level Categories on the vertical axis:
How-to Easily Create a Stacked Clustered Column Chart in Excel

Here is the sample file: Grouped Missions.xlsx

Please let me know if this helps.

Steve=True

Wow! That's good - thanks so much. Client is very happy......

Dimonds,

That is so wonderful.

Glad I was able to help.

Thanks for the feedback.

Steve=True