Share via

Create an easily maintainable timeline in Powerpoint

Robert Marteau 0 Reputation points
2025-11-26T11:28:12.5566667+00:00

Hi,

Here's the context that will help you understand what I'm trying to achieve here:

I have a recurrent weekly meeting about builds being deployed (or not) to different IT environments (example: UAT, ITT, Production). Say for example:

November 26 meeting: We approve build 3.1 for Production, build 4.1 for ITT testing and build 5.1 for UAT testing.

December 2nd meeting: We request that build 4.1 (which was in ITT) goes to production, build 5.1 goes from ITT to UAT and we received a new 6.1 build that we will test in UAT.

and so on each week...

--> I'd like to add a slide to the existing PowerPoint presentation that contains a timeline of when each build is on which environment, what is in store for the foreseeable future as well as (via animation on click or hover) the content of said build (list of bug fixes, changes,...).

It is of course easy to create a "static" timeline that shows the situation in a given timeframe (6 weeks), but that's not easy to maintain, since each week, I'll have to change the timeline dates, remove the content of the oldest week, "slide" the whole content to the left and add a new week to the right.

In order to solve this, I went the Excel route, which is promising:

I created an excel file with all weeks (for a year for example) as columns, different environments as rows and builds for week (column X) and environment (row Y) in the cells. I then copied (and linked) the content of the table to the Powerpoint, so that when I update the Excel, I update the PPTX at the same time.

I struggle however with the way to "move" the 6 weeks window from week to week, keeping it current (or rather "centered on the current date", with view on the past & the future)

Any idea about the best way to do that ?

Microsoft 365 and Office | PowerPoint | For business | Windows
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2025-11-26T11:28:29.55+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    To create an easily maintainable timeline in PowerPoint that reflects your weekly meetings about builds being deployed, you can leverage the Excel integration you mentioned. Here’s a suggested approach to keep your timeline current and centered around the current date:

    1. Dynamic Excel Table: Continue using Excel to manage your timeline data. Create a dynamic table that includes all weeks of the year as columns and different environments as rows. Populate the cells with the corresponding builds for each week.
    2. Use Formulas for Current Week: In your Excel file, you can use formulas to determine which six-week window to display based on the current date. For example, you can use the TODAY() function to find the current week and then calculate the range of weeks to display (e.g., the three weeks before and the three weeks after the current week).
    3. Link to PowerPoint: Once your Excel table is set up, link it to PowerPoint as you have done. This way, any updates in Excel will automatically reflect in your PowerPoint presentation.
    4. Update the View: Each week, you can adjust the formulas in Excel to shift the view of the timeline. This could be as simple as changing a reference in your formulas to point to the new current week, which will automatically update the PowerPoint slide when refreshed.
    5. Animation for Details: For the animation part, you can set up PowerPoint to show additional details (like bug fixes and changes) when you click or hover over specific elements of the timeline. You can use shapes or text boxes linked to your Excel data to display this information dynamically.

    By following this approach, you can maintain a current and relevant timeline without needing to manually adjust the content each week, making it easier to keep your presentation up to date.

    References:

  2. Robert Marteau 0 Reputation points
    2025-11-26T11:53:36.3666667+00:00

    Could you please be more specific about using formulas for current week display? Is this done via "custom views" ?

    0 comments
  3. Nam-D 485 Reputation points Microsoft External Staff Moderator
    2025-11-26T15:17:58.1233333+00:00

    Hi @Robert Marteau,

    Thank you for sharing the details of the issue. We’ve tried to reproduce it on our side, but to provide the most accurate solution, we’d like to review a sample that reflects your actual structure.

    Could you please create a sample file showing the problem, upload it to your OneDrive, and share the link with us via private message? If needed, feel free to remove any sensitive data before sharing. "I’ve sent you a private message. Please click the button shown in the picture below to view it.

    User's image

    Your help will allow us to analyze the issue more effectively and provide the best possible resolution. Please let us know if you need guidance on creating or sharing the file.Thank you for your patience and understanding.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.