Template Issues

How to Expand the Agile Gantt Chart Template View in Spreadsheet

Algirdas Jasaitis Sep 30, 2026 870 views

Question details

The user needs to expand the visible timeframe in an Agile Gantt Chart template to display up to 365 days instead of the default two months, and remove the horizontal scroll bar.

How to Expand the Agile Gantt Chart Template View

Product: Spreadsheet
Device & OS: not provided
Scenario: Planning and visualizing a long-term project timeline using a pre-formatted Gantt chart template.
Observed behavior: The current template restricts the visual timeline to two months and uses a scroll bar to navigate through the year, preventing a comprehensive project overview.

Before you start

Before modifying the Gantt chart template structure, save a backup copy of your original file to prevent accidental loss of complex conditional formatting rules or date formulas.

Solution 1Recommended

Manually Copy and Extend Chart Cells

Extend the default two-month view by manually copying the timeline columns to the right and updating the date formatting formulas.

This method involves unlocking the template and manually expanding the data range. By dragging the formulas and conditional formatting across new columns, you can display four months or a full year seamlessly.

Unprotect the Worksheet

Navigate to the 'Review' tab on the top ribbon and click 'Unprotect Sheet'. If a password is required, enter it to allow structural modifications.

Select the Timeline Columns

Highlight the right-most columns of the existing chart view containing the daily or weekly date headings.

Copy and Paste to the Right

Copy the selected columns (Ctrl+C) and paste them (Ctrl+V) into the empty columns immediately to the right to add the additional months you wish to display.

Update Month and Date Formulas

Click on the newly pasted month headings and adjust the formulas so they reference the previous month's end date, ensuring the timeline continues chronologically.

Adjust Conditional Formatting Rules

Go to 'Home' > 'Conditional Formatting' > 'Manage Rules'. Update the 'Applies to' range for all Gantt chart rules to include the newly added columns.

Scroll Bar Removal: Once you have expanded the columns to fit your desired timeframe, you can delete the interactive scroll bar developer control by right-clicking it and pressing Delete.

Solution 2

Use an Alternative Yearly Gantt Chart Template

Switch to an advanced Gantt chart template built with Power Query and Power Pivot that natively supports a one-year view without scrollbars.

Simplify Project Management

Effortlessly Manage Project Schedules with WPS Spreadsheet

WPS Spreadsheet offers an extensive library of customizable Gantt chart templates. You can easily expand timelines, modify formulas, and track complex projects without encountering formatting limitations.

1. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' from the main dashboard.
2. Access the Template Library: Click on 'New' and select the 'Templates' tab to browse the built-in template gallery.
3. Search for Gantt Charts: Type 'Gantt Chart' into the search bar to find templates that offer full-year or extended month views natively.
4. Apply and Customize: Select your preferred template, click 'Use Now', and seamlessly input your project dates to automatically generate your extended timeline.

Seamlessly compatible with Microsoft Excel (.xlsx, .xls) files and formulasRich library of free, ready-to-use professional Gantt chart templatesLightweight application with robust conditional formatting toolsFamiliar user interface for quick and easy timeline adjustments

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Gantt chart template use a scroll bar instead of showing all months?

Many templates use a scroll bar tied to the OFFSET formula to keep the chart visually compact and fit within a single screen view. This prevents the spreadsheet from becoming too wide and difficult to print, but it sacrifices the ability to see the entire project at once.

Will copying cells break my conditional formatting in the Gantt chart?

Copying and pasting the cells will duplicate the conditional formatting for those new cells. However, to ensure the chart functions perfectly, you should verify the rule ranges in 'Conditional Formatting' > 'Manage Rules' to confirm the formulas apply correctly to the newly expanded columns.

Can I change the timeline scale from days to weeks in my current template?

Yes, you can alter the scale by changing the date formulas in the column headers. Instead of adding +1 to the previous cell for days, you can add +7 to step by weeks. You will also need to adjust the conditional formatting rules to evaluate whether a task's duration falls within that specific week.

Document & File Issues