how to create gantt chart with numbers?

Hi Anatoly,

I downloaded your Gannt chart fromhttps://yadi.sk/d/EsoDdJ303Fi4m6 and opened it in Numbers for Mac. Excellent work!

A 2D Stacked Bar Chart with white fill for Start Date. So simple!

I deleted some rows (items) from Table 1 but the chart Y axis stayed at 35 items, with no bars for the missing items.

To make the chart more interactive, we can select whole Columns A, B and C in table 1

and insert a new 2D Stacked Bar (Table and Chart are both on the same Sheet for clarity):

Now we can add (or delete) items (I added Item 12 to Table 1)

and the chart automatically updates.

Thank you for such a simple solution to this 4 1/2 year old question!

Regards,

Ian.

Hey guys,

I've made Gantt's chart template for my workflow and it took around 40 minutes to fill data in table.

You can download it here https://yadi.sk/d/EsoDdJ303Fi4m6

I've put comments in two cells of the table of first sheet.

Some detail (in case if don't understand comments inside the file): in case your stage starts from first day and its duration is one or two or more days/months/minutes etc just put in "Start date" 0 and in "End date" number according to duration; in case if your stage starts in middle just put in "Start date" number of starting day/month/minute etc and add exact days/months/minutes etc to get correct indication in the chart: for example, if my stage starts in ninth month and will finish in twelve month, I put 9 in "Start date" and 3 in "End date".

Hope it will be useful.

HI Jerrold,

Your template is exactly what I have been trying to build on my own without success. Could you send me a copy too, please?

Thank you in advance for creating and sharing your template 🙂

-Manoel

FLOURISH22 wrote:

Hi Barry,

Would you mind sending me a copy of your Gantt chart please. It looks very useful.

Neither Jerry nor Barry seem to have been active in this thread for a while. You might check out some of the links to files people have posted.

Kimber's iPhone wrote:

Hi Jerry,

This looks great!

Any chance I can get a copy of this?

Jerry does not seem to have been active in this thread since 2014. You might check out some of the links to files people have posted.

sealrocker wrote:

Hi Jerry. You're very generous to share your Gantt template. If not too much trouble, please also send a copy to

I do not believe Jerry has been active in these forums for some years.

Alexander,

Numbers (and Excel) are not the best tool for Gantt charts. There is a free Project management software package called OpenProj. Ultimately I spent the money to get OmniPlan. There are several others in the Apple App store for project management. If you want to use a spreadsheet like excel to make a gantt chart I would think you can use a similar method to what you used to do.

There is also a free office suite called Libre Office which is more similar to MS Excel.

Alexander,

I may be able to help if you can show or share in some way, what you did in Excel.

Hi!

I have tried both Excel and Numbers but in the end i found that there is almost allways to much work in setting them up and working in them so I went over to www.tomsplanner.com.

Wayne: Are you still working in and happy with Omniplan?

All the best

Magnus

Alexander,

I built this template a few years ago in iWork '09 Numbers. It is primative in terms of project management features, but it makes a nice chart for inclusion in a report. I loaded is as a template in Numbers 3.0 and it seems to be functional.

I see your question is marked as solved, but I thought you might have some interest in this anyway...

Regards,

Jerry

Hi Jerrold, this is lovely. Can I get it please? I will come in very handy. Thanks

Kananga,

I don't see an address in your profile, so send me an email and I'll return the template to you.

Jerry

Thanks Jerrold, will do that right now.

Rgds

K