Gantt Chart for numbers

Hi Khaled,

I can post instructions on making one here, if that would be helpful.

Direct email between ASC users is discouraged by Apple to the extent of including an instruction in the TOU agreement not to post your address in a 'public' space (such as a message in this forum), where wandering 'bots can collect it and sell it for nefarious purposes.

Regards,

Barry

This simple Numbers document (Dropbox download) may fit your needs. You can drag the rows to change the order of the tasks.

SG

If you can work with Barry directly, that is best, He is very good,

But for future issues (or this one even still), You can use almost any Excel template that you can find on the web. Just make sure it does not require macros and it should work fine. (basically just charting hacks for this case)

Jason

"Yes, that would be great if you can help me create one"

Here's the overview:

Project Schedule Input is a data table. Rows 1 and 2 are Header Rows.

All information shown on this table is entered directly. See box to right of the table for description of the data to be entered.

Calculations contains entered labels in Row 1 (a Header Row).

Column A is a Header column.

Each column of this table contains a formula, entered in row 2, then filled down to the last row of the table.

A2: IF(ROW()−2>COUNTA(Project schedule input::$B),"",OFFSET(Project schedule input::$B$1,ROW()−1,0))

B2: IF(ROW()−2>COUNTA(Project schedule input::$B),"",SUM(D2:E2))

C2: IF(ROW()=2,0,IF(ROW()−1>COUNTA(Project schedule input::$B),"",OFFSET($A$1,MATCH(OFFSET(Project schedule input::$B$1,ROW()−1,1),$A,0)−1,1)))

D2: IF(ROW()−2>COUNTA(Project schedule input::$B),"",SUM(C2,OFFSET(Project schedule input::$B$1,ROW()−1,2)))

E2: IF(ROW()−2>COUNTA(Project schedule input::$B),"",OFFSET(Project schedule input::$B$1,ROW()−1,3))

Column F was used in the development of the document, but is not used (and contains nothing other than the label) in the finished version. It can be omitted.

The 'normal' type part of each formula is the same in each, and acts as a 'switch' to prevent calculation (and the resulting error messages) in rows beyond the number of rows of data in Project Schedule Input.

The initial IF in C places a zero in C2,

The bold part is the 'core formula' that produces the results seen in the Calculations table.

Details of the workings of each formula have been omitted for brevity, but are available on request.

The chart

The chart is a horizontal Stacked Bar chart, fed by the data in columns D and E of Calculations.

Category names (Phase names) on the chart are gathered from the Heder column (A) of Calculations.

Values for each bar are displayed in the middle of the bar.

The x axis (value axis) is set to use as many steps as there are weeks in the project (plus enough to make a round number, and provide space for delays).

Regards,

Barry

Major grid lines are set to a medium grey line with a weight of 1 pt.

Hi Ian & SG,

Actually it was Jerrold Green1 who had the foresight to included all phases, and who, in those simpler times, decided 10 weeks was a 'reasonable' (or perhaps 'fitting') period for the final phase.

I just reproduced his document when it became apparent he was no longer responding to emailed requests for copies of the file.

Regards,

Barry

Hi Khaled,

" I want to rent a place two weeks before the end of the project so I want the ( rent Place ) activity to depend on the end of the project to start two week before it and appear on Gantt chart and reflect on the calculations Table, What formula should I use?"

There's no need for an extra column. If "the end of the project" is the end of the "construction" phase (as on the chart in my example), start by adding a row to the Project Schedule Input table.

Note that this line names the phase, names the phase whose end date determines the start date of this phase (blue arrow), specifies the 'delay' from that end date (in this case -2, as this phase is to start 2 weeks before the end date of Construction) and specifies the length (duration) of this phase.

Add a row to the Calculations table. The formulas in this table will automatically fill into the new row.

Click on the chart to select it, then click Edit Data References.

The current data references will show in the Calculations table as all body cells in columns D and E except those in the last row.

Grab the white circle at the bottom right corner of the selection rectangle, and drag it down to include the bottom row of data.

A new bar will appear on the chart, labelled with the phase named in the last row of the Calculations table.

*NOTE: I added the new phase to the bottom of the Project Schedule Data table, but you may want to place it in a different position. The order of items (top to bottom) on the chart is determined by the order of those items in column A of Project Schedule Data, so you may want to Insert a new row on that table rathr than add it to the end of the table. Other instruction remain the same.

Regards,

Barry

Hi Barry,

I admire your full consideration of all possible phases 😎.

Regards,

Ian.

But 10 weeks isn't enough for that phase. Barry probably meant 10 years, but couldn't fit it into the screenshot.🙂

SG

You're welcome, Khaled! I'm happy you found it useful.

Regards,

Barry