Dear Excel Gurus,

I'm looking for a way to develop a planning tool I would use to show the project rollout per specific countries over the year. My idea is to have two sheets: one INPUTS sheet to enter rollout dates per project and per country, and one DASHBOARD sheet which would show a yearly timeline of rollouts. The axis X should show the months from Jan to Dec in format mm.yyyy, and axis Y would show the projects. Inputs of rollout dates would be entered in format dd.mm.yyyy. And now the tricky part: The dashboard should show a small country flag on the timeline for a particular project on a particular date. For example: On the INPUTS sheet for project ABC I would enter a rollout date 15.11.2017 for Germany and 20.12.2017 for Greece. Project XYZ would rollout in Belgium on 25.10.2017 and in Germany 30.12.2017. Project 123 would rollout in UK on 17.11.2017, etc... Then, the timeline should show the small country flag of Germnay, Greece, Belgium and UK for corresponding projects on the corresponding date. In case, the same date is entered for two countries for the same project, the flags should not cover each other - so they are visible.

Any helping answers are much appreciated. In case you are aware of a tool whit such functionality it would also help to advise it.

Thank you very much in advance.

Regards,
Link