Forum Discussion

tgarner's avatar
tgarner
Copper Contributor
Jul 16, 2024

Stacked Bar Chart as Office Timeline

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

 

 

Charting
excel
office 365

7 Replies

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Jul 16, 2024

    tgarner 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

    • tgarner's avatar
      tgarner
      Copper Contributor
      Jul 17, 2024

      HansVogelaar sure - a small sample graph is linked below.

       

      https://martinriley221-my.sharepoint.com/:x:/g/personal/tgarner_martin-riley_com/EclZcVBYgvlEpFswbrpnDYMBGirPtiT63_YNSqEnKSZkow?e=jBJZdJ

       

      It's getting closer to what I want, but I need to be able to match the phase's ending dates to the perpetual calendar so the colors change on the correct date.

       

      Thanks for your help!

      Traci