Share via

Condensing Timelines in Excel

Anonymous
2017-12-18T21:21:50+00:00

If I have created a timeline in excel, how do I decrease the length of time in the timeline while condensing the info and keeping it consistent? For example, I have created a 12-month planning timeline, but if I need to condense to a 6-month planning timeline... how do I convert that timeline to 6 months, while keeping the info consistent so the "checklist" items automatically distribute evenly and accordingly to the decreased time?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-12-19T20:50:17+00:00

    Hi Jenna,

    There are several ways to customized your timelines in Excel. You can add more dates, move dates, change layouts and colors and apply different styles. Since you want to condense your 12-month planning timeline to 6-month planning timeline only, we suggest that you check out this support article. You can achieve your desired result by using PivotTable by following the steps on the link that we have provided.

    If the steps provided in the link do not work for your timeline, send us a link of your sample data file so we can further assist you.

    Update us on how it goes.

    Was this answer helpful?

    0 comments