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, slo...
Charting
excel
office 365
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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jul 17, 2024

      tgarner 

      That is problematic. Why are some dates at the beginning missing?

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

        HansVogelaar the dates are entered in our accounting software by the project managers, and they sometimes leave fields blank, because not all projects' contracts have all phases in them. But they  all have project start dates - should I add a column for project start and make that my 'base date?'