I am using Microsoft 365, but I do not have access to Power BI.

I am trying to create a stacked bar chart as a replacement for our firm’s Office Timeline, which currently exists on our outdated, slowly dying intranet site. What I’m looking for is something similar to this:

Projects will be on the Y axis, with a perpetual calendar on the X axis – the color changes represent the end of each project phase, and the black boxes represent milestone dates within the phase.

I have brought in the data, added a perpetual calendar and formatted the dates as numbers. I established a ‘base date’, but I’m not sure that I need it. The resulting stacked bar chart is not even close to what I’m trying to do, and I think the reason is that I need to incorporate a formula to match the ending phase dates to the perpetual calendar (see the data example below). 

Do any of you know of a tutorial I could study or a general method to do what I’m trying to accomplish? I have looked at dozens of articles and YouTube videos and I can’t find anything that addresses this.

Thanks,

Traci

​I am using Microsoft 365, but I do not have access to Power BI.I am trying to create a stacked bar chart as a replacement for our firm’s Office Timeline, which currently exists on our outdated, slowly dying intranet site. What I’m looking for is something similar to this:Projects will be on the Y axis, with a perpetual calendar on the X axis – the color changes represent the end of each project phase, and the black boxes represent milestone dates within the phase. I have brought in the data, added a perpetual calendar and formatted the dates as numbers. I established a ‘base date’, but I’m not sure that I need it. The resulting stacked bar chart is not even close to what I’m trying to do, and I think the reason is that I need to incorporate a formula to match the ending phase dates to the perpetual calendar (see the data example below).  Do any of you know of a tutorial I could study or a general method to do what I’m trying to accomplish? I have looked at dozens of articles and YouTube videos and I can’t find anything that addresses this. Thanks,Traci    Read More

​