Totaling numbers in a gantt chart

Copper Contributor



I'm using Excel to create a fairly rudimentary gantt chart with a bunch off conditional formatting to show weekends and RDO's to create a schedule for a project. To fill in a "square" which is a working date, we enter in a number, which relates to the number on men on the site, on that date. That might be 4 days with 8 men, to form a block of labour required for that taask.


The difficulty is that if we want to move one of those numbers, the process of moving the balance of numbers take so long, as its basically got to be manually rekeyed to take into account the weekends (and RDO's / Xmas etc.)


An easier method would be to drag and drop the blocks, but this completely messes with formulas totaling for that date, and the conditional formatting.


Is there a way to manage this in a easier format? I would imagine we could do something similar with Project, but its far to complicated to setup for the info we're trying to get out of it.

1 Reply


To manage dragging and dropping blocks in your Gantt chart without disrupting the formulas and conditional formatting, you can use Excel's Table feature.

Here is how you can set it up:

  1. Select the range of your Gantt chart data, including the headers.
  2. Go to the Insert tab in the Excel ribbon and click on "Table".
  3. In the Create Table dialog box, make sure the "My table has headers" option is checked and click OK.

By converting your data range into a table, Excel will automatically apply structured referencing to your data, which makes it easier to work with and maintain formulas.

Now, when you drag and drop the blocks within the table, the formulas and conditional formatting will adjust automatically based on the structured referencing. This allows you to move the blocks without manually rekeying the data or disrupting the calculations.

Additionally, you can use Excel's built-in table features, such as sorting, filtering, and adding new rows, to further manage and manipulate your Gantt chart data easily.

By using this approach, you will have a more dynamic and efficient way of managing your Gantt chart while preserving the formulas and conditional formatting. The text was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.