Chart & Visualization Issues

How to Fix Excel Gantt Chart Bars Not Updating for Custom Tasks

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to fix a Gantt chart template where graphical bars fail to display after replacing the default sample data with custom task entries and dates.

Product: Excel
Device & OS: not provided
Scenario: Modifying a Date Tracking Gantt Chart template with custom project data.
Observed behavior: The chart correctly displays bars for the default sample tasks, but no bars appear when custom text and dates are entered.

Before you start

Ensure that the custom dates you entered match the exact date format and data type used in the original Gantt chart template.

Solution 1Recommended

Adjust Conditional Formatting Ranges and Rules

Expand the conditional formatting rules to cover your new custom rows so the Gantt chart bars render correctly.

Gantt chart templates often rely on conditional formatting to draw the bars across the timeline. If you add new rows for custom tasks, the existing formatting rules might not automatically apply to the new ranges, causing the bars to remain invisible.

Highlight the Timeline Area

Select the entire area of your Gantt chart where the bars are supposed to appear, including the newly added custom rows.

Open Conditional Formatting Manager

Navigate to the Home tab on the ribbon, click on 'Conditional Formatting', and select 'Manage Rules' from the dropdown menu.

Verify the Rule Range

Locate the rule governing the Gantt chart bars and check the 'Applies to' range to see if it includes your new rows.

Update the Applies to Range

Modify the 'Applies to' range to encompass all custom task rows. You can click the arrow next to the field and highlight the expanded area.

Apply Changes

Click 'Apply' and then 'OK' to save the changes and force the Gantt chart bars to render on your custom tasks.

Check Formatting: Ensure your custom task dates and status values perfectly match the template's required format, otherwise the formula within the rule will not trigger.

Solution 2

Recreate the Gantt Chart Formatting Rule

If the existing rule is broken or improperly referenced, deleting and recreating a simpler conditional formatting rule can resolve the issue.

Manage Projects with WPS Office

Create and Manage Gantt Charts Effortlessly in WPS Spreadsheet

WPS Office provides built-in project templates and robust conditional formatting tools, making it incredibly simple to build customized Gantt charts without dealing with broken formulas.

1. Open a Gantt Chart Template: Launch WPS Spreadsheet, go to the Homepage, and search for 'Gantt Chart' in the Template library.
2. Enter Your Project Data: Input your custom task names, start dates, and durations into the designated columns of the template.
3. Automatically Generate Bars: Watch the Gantt bars automatically update as WPS seamlessly handles the underlying conditional formatting ranges for you.

Easily customize pre-built Gantt chart templates for your specific project needs.Fully compatible with Microsoft Excel (.xlsx) formats and complex conditional formatting rules.Intuitive interface for managing task dates, statuses, and project timelines.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Gantt chart bars disappear when I copy and paste data?

Standard pasting can overwrite the underlying conditional formatting rules or introduce mismatched text and date formats into the cells. Try pasting as 'Values Only' (Right-click > Paste Special > Values) to preserve the chart's formatting rules.

How do I fix date format errors in my Gantt chart?

Select your date cells, right-click, and choose 'Format Cells'. Ensure the date format perfectly matches the locale and format expected by the chart's formatting formula so that the system recognizes them as valid dates.

Can I change the color of the Gantt chart bars?

Yes. Go to the Home tab, click Conditional Formatting > Manage Rules, select the rule creating the bars, click 'Edit Rule', and change the Fill color in the Format options menu.

Excel & Data Problems