Hi<br><br>Try using "Autoshapes - Elbow Connector". It does the same thing in one click.<br>If you can't find Autoshapes in Excel, open the toolbars - 2 clicks<br><br>Joseph Papaleo<br><br><br><br><br><br><div>
<span class="gmail_quote">On 14/02/2008, <b class="gmail_sendername">Jeffrey Lynn</b> <<a href="mailto:jslynn@optusnet.com.au">jslynn@optusnet.com.au</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Antonia.<br><br>This is good.<br><br>I teach this in much the same way, only using the drawing tools to produce<br>the dependency arrows and milestone diamonds.<br><br>To create an arrow, I get the students to draw a horizontal line, then a<br>
separate vertical line with arrow. Then the two are butted up and grouped.<br>Next, reduce the size to something that suits the Gantt chart and finally,<br>copy as many times as needed. The grouped shape can be stretched to<br>
accommodate any distance down the Gantt chart and two may be superimposed to<br>create multiple dependencies.<br><br>Additionally, for those who wish to emulate something like MS Project, a<br>thicker line may be drawn within the Excel cells that form the time bar to<br>
create a progress indicator.<br><br>I hope this helps someone while not annoying others who already do things<br>this way.<br><br>Jeff Lynn,<br>Hales Institute,<br>Melbourne, 3000.<br><br><br><br>-----Original Message-----<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>]<br>On Behalf Of Antonia Caridi<br>Sent: Monday, February 11, 2008 2:05 PM<br>
To: Year 12 IT Applications Teachers' Mailing List<br>Subject: Re: [Year 12 IT Apps] Project Management Software<br><br>attached is a doc sent to the list in 2001 (!!!) explaining how to create<br>Gantt charts with milestones, predecessors, etc in Excel - Antonia<br>
<br>Antonia Caridi<br>Sacre Coeur<br>172 Burke Road<br>Glen Iris 3146<br>Telephone 9885 4501<br>Fax 9885 5936<br><br><br>èµ__________________________________________________________________________<br>________<br>This email and any attachments may be confidential and, if you are not the<br>
intended recipient you must not disclose or use the information in this<br>email. If received in error, please notify the sender immediately and delete<br>the email and all copies. The school does not guarantee that this email is<br>
virus or error free. Any attached files are provided and may only be used on<br>the basis that the recipient assumes all responsibility for any loss, damage<br>or consequence resulting directly or indirectly from the use of this email<br>
and/or attached files, whether caused by the negligence of the sender or<br>not. The content and opinions in this email are not necessarily those of<br>Sacre Coeur.<br>____________________________________________________________________________<br>
________<br>_______________________________________________<br><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> -<br>Victorian Curriculum and Assessment Authority and<br><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers<br>
Association Inc<br><br><br>_______________________________________________<br><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc<br>
</blockquote></div><br><br clear="all"><br>-- <br>Joseph Papaleo<br><br>"We seek your leadership, but if for some reason you are not willing to lead, leave it to the rest of us. Please get out of the way." <br>Kevin Conrad, PNG delegate to the US at the UNFCCC, Bali.<br>
<br>Computers & 21C Eduk8n<br><a href="http://papajo.edublogs.org">http://papajo.edublogs.org</a>