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.
Bookmarks