Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how to create gantt chart with numbers?

i'm a new user of numbers, as I use microsoft excel to create gantt chart before,it' s easy, but now, I like to use mac numbers, possibly, I'm not familiar with numbers, so i couldn't find a way to solve the date as a value and reverse the axises. Could somebody like to help me to solve this? Thanks.

Posted on Feb 10, 2013 7:22 PM

Reply
Question marked as Best reply

Posted on Sep 7, 2017 3:59 AM

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

User uploaded file

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

User uploaded file

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

User uploaded file

and the chart automatically updates.

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


Regards,

Ian.

189 replies

Feb 12, 2014 9:45 AM in response to ayol13

Ayol,


Apparently this thread has had lots of hits in Google searches and I'm getting regular off-discussion emails requesting the template.


At the current rate, I can continue to respond, but if it picks up I may have to find another way to host and serve the document.


I can't send documents to discussions participants who don't display their email address in their profiles. See my response to Kananga above.


Jerry

how to create gantt chart with numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.