Excel Hack 87: Create a dynamic timescale in Microsoft Excel
Here is how to set up your Excel worksheet with the flexibility to update the time unit as required. In the example below, the flexible timescale has been created for a Project Gantt Chart, and users want to retain the ability to view the project task timelines in days, weeks, or months. This has been