Yesterday I received an enquiry about how Google Spreadsheets could be used to prepare Gantt Chart for a project.
I searched for 'gantt' on Google Docs Templates Gallery and found 3 templates. I decided to use the simplest one:
On clicking 'Use this template' a copy was saved on my Google Docs and it opened before me. There were 15 activities on the Template which I modified for my project. Since there were more than 15 I inserted more rows and put all the activities. I maintained the format of the template and used 2.00, 3.00 etc. in WBS column for main activities and 2.11, 2.12 for sub-activities of 2.0 and so on.
After finishing with activity sheet I clicked on the second sheet to see the Gantt Chart. The chart was having 15 activities only whereas I had 26 on the activity sheet. Then I clicked on 'Edit Settings' tab on the chart and changed the range to 'A1:G27' and applied. The Gantt chart started showing all 26 activities.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment