Options for making a Gantt chart Microsoft Excel has a Bar chart feature that can be formatted to make an Excel Gantt chart. If you need to create and update a Gantt chart for recurring communications to clients and executives, it may be simpler and faster to create it in PowerPoint. On this page, you can see both ways. I will give you step-by-step instructions for making a Gantt chart in Excel by starting with a Bar chart. I will also show you how to instantly create an executive Gantt chart in PowerPoint by pasting or importing from Excel. • Break down the entire project into chunks of work, or phases. These will be called, and they form the basis of your Gantt chart. • In Excel 2007, 2010, 2013 or 2016, enter your data by listing the Start Date and Finish Date of each task, as well as its Duration (count of days required to complete that task). Also include a brief description of the task. Make sure to sort these tasks in order, by placing the earliest start date first and the latest start date last. • In this tutorial, I will convert the following table into an Excel and a PowerPoint Gantt chart. • Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window. • On the left side of Excel's Data Source window, you will see a table named Legend Entries (Series). Click on the Add button to bring up Excel's Edit Series window, and here you will begin adding Task data to your. • Now we're going to add your task data. First we need to name the data (Series) we will be entering. Click and place your cursor in the empty field under the title Series name, and then click on the column header that reads Start Date in your table. Staying in the Edit Series window, move down to Series value. This is where you will enter your Task start dates. It is easy to do. To the right of the Series values field, you will see an icon which looks like a spreadsheet with a red arrow on it. Click on it (the one by Series values), and Excel will open a smaller Edit Series window. Now simply click the first start date in your task table and drag your mouse down to the last start date. This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Make sure you have not mistakenly highlighted the header or any extra cells. When finished, click on the small spreadsheet icon again (the one with the red arrow), which will return you to the previous window, called Edit Series. Your Gantt should now look like this. • Staying in the Select Data Source window, click on the Add button again to bring up Excel's Edit Series window. • Here we will add the duration data to your Gantt chart. In the Edit Series window, click in the empty field under the title Series Name, and then click in your Task table again, on the column header that reads Duration. Staying in the Edit Series window, move down to Series value and click on the spreadsheet icon with a red arrow on it again. Select your Duration data by clicking on the first Duration in your project table and drag your mouse down to the last duration so that all durations are now highlighted. To exit, once again click on the small spreadsheet icon with the red arrow, which will return you to the previous window. Select OK, and you should now be back at the Select Data Source window. Click OK again to build your Gantt chart, which should now look something like this. • Right-click on one of the blue bars in the Gantt chart, and then click on Select Data again to bring up the Select Data Source window. • On the right side of Excel's Data Source window you will see a table named Horizontal (Category) Axis Labels. Select the Edit button to bring up a smaller Axis Label windows. • Again, click on the small spreadsheet icon. Click on the first name of your tasks (my first Task description is 'Preparatory Phase') and select them all. Be careful not to include the name of the column itself. When you are done, exit this window by clicking on the small spreadsheet icon again. • Click on OK and then OK again to exit the Select Data Source window, and now your Gantt chart should have the correct Task descriptions next to their respective bars. Your chart should now look something like this. 12-month timeline Word Project planning timeline Word Timeline with flags infographic (Berlin theme, widescreen) PowerPoint Timeline (blue horizontal chevrons, widescreen) PowerPoint Event timeline diagram slide (widescreen) PowerPoint Business Timeline SmartArt Diagram Slide (white on dark gray,. Quickly create professional project visuals that showcase your work and impress customers, colleagues, and managers. Office Timeline is the only Gantt chart and timeline maker software built for Knowledge Workers, right inside Microsoft PowerPoint. It easily produces elegant Gantt charts and timelines that no other. • To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series, which will bring up the Format Data Series window in Excel. • In the Format Data Series task pane, click on the Fill & Line icon (it looks like a paint can) to get the Fill & Line options. Under Fill, choose the No Fill radial button and under Border choose the No Line option. Don't close the Format Data Series task pane because we're going to use it in the next step. Your Gantt chart should now look like this: • You probably also see that the tasks on your Gantt chart are listed in reverse order, with the last task on top of the Gantt chart and the first Task listed at the bottom. This is easy to change in Excel. To do so, click on the list of tasks along the vertical axis of your Gantt chart. This will select them all and it will also open the Format Axis task pane. Click on the Bar Chart icon in the Format Axis Task Pane and expand out the Axis Options menu. In the Format Axis task pane, under the header Axis Options and the sub-header Axis Position, put a check into the checkbox called Categories in reverse order. You will notice that Excel arranged your tasks into proper order, listing them from first to last on your Gantt chart. You will also notice that Excel moved the date markers from beneath to the top of the Gantt chart. Now it is really starting to look more like a Gantt chart should. • Optimize the Gantt chart Removing some of the blank white space where the blue bars used to be will bring your tasks a little closer to the vertical axis of your Gantt chart. To remove some of the blank white space in the chart, click on the dates above the task bars. One click should select all the dates. Then, right-click and select Format Axis to bring up Excel's Axis Options window. In the Axis Options window, under the header called Bounds, note the current number for Minimum Bounds. It represents the left most boundary of your Gantt chart. Changing this number by making it larger will bring your tasks closer to the vertical axis of your Gantt chart. In my case, I changed the original number from 41750.0 to 41820.0. At any time, you can hit the reset button to return to the original settings. This gives you the opportunity to try a number of different settings until you find the one the makes your Gantt chart look best. • Adjust the density of the dates across the top of your Gantt chart In the same Axis Options window, under the header Units, you can adjust the spacing between each of the dates listed at the top of the horizontal Axis. If you increase the unit number, your Gantt chart will enlarge the space between each date, which will also lessen the number of dates your Gantt chart shows. Doing the opposite reduces the space between each date and therefore crowds more dates onto your Gantt chart. In my case, I changed the original number from 20 to 30. • Thickening Task bars on your Gantt chart to reduce white space Right-click on the first Task bar and choose Format Data Series to open the Format Data Series control. Under the Series Options header, you will find the Gap Width control. Sliding it up or down will increase or reduce the size of your Task bars on your Gantt chart. Play around until you find something that works best for you. • Inside PowerPoint, navigate to the Office Timeline Plus tab and click the New button. This will open a gallery that will allow you to choose a style or template for your Gantt chart. • From the gallery, double-click any template or style to select it and then click Use Template in the preview window to open the Data Entry Wizard. In this demonstration, I will be using a custom template. NOTE: If you prefer to your Excel table, rather than copy-paste, select Import. • Copy your project's details, including Start Date, End Date and Description, from the Excel table you made earlier. You can copy them all at once, but be sure not to copy the title. • Now simply paste the data into PowerPoint using the Office Timeline Plus button. Then, make any edits you wish (change colors or shapes, add or remove items, etc.) and click Create. Contents • • • • • • • • • • • • • Windows versions [ ] Release date Title Components Notes November 19, 1990 Office 1.0 Word 1.1, Excel 2.0, PowerPoint 2.0 March 4, 1991 Office 1.5 Word 1.1, Excel 3.0, PowerPoint 2.0 July 8, 1991 Office 1.6 Word 1.1, Excel 3.0, PowerPoint 2.0, Mail 2.1 Last version to support August 30, 1992 Word 2.0c, Excel 4.0, PowerPoint 3.0, Mail 3.0 Later rebranded as Office 92 January 17, 1994 Office 4.0 Word 6.0, Excel 4.0, PowerPoint 3.0, Mail 3.1 June 2, 1994 Office 4.3 Word 6.0, Excel 5.0, PowerPoint 4.0, Mail 3.2, Access 2.0 This is the last 16-bit version. This means that it is also the last version to support, July 3, 1994 Office for NT 4.2 Word 6.0, Excel 5.0, PowerPoint 4.0, Office Manager Runs on August 24, 1995 (7.0) Word, Excel, PowerPoint, Schedule+, Binder, Access, Bookshelf Coincided with the operating system release. Works only on Windows 95 as well as and later. This is the first Office version to have the same version number (7.0, inherited from Word 6.0) for all major component products (Word, Excel and so on). November 19, 1996 (8.0) Word 97, Word 98, Excel, Outlook, PowerPoint, Access, BookShelf Basics, Publisher 97, Publisher 98, Small Business Financial Manager 97, Small Business Financial Manager 98, Automap Street Plus, Direct Mail Manager, Expedia Streets 98 Was published on as well as on a set of 45 3½-inch, became -safe with Service Release 2, and was the last version to support. June 20, 1997 Office 97 Powered by Word 98 (8.5) Was released only in Japanese and Korean editions. First version to contain Outlook 98 in all editions and Publisher 98 in the Small Business Edition, as well as the first version of Office 97 to support Windows 98 Second Edition. June 7, 1999 (9.0) Word, Excel, Outlook, PowerPoint, Publisher, Small Business Tools, Access, FrontPage, PhotoDraw First Version to Support, and last version to support. Office 2000 is also the last version not to include and not covered by, although on individual installs, the Office Update website still required the presence of original install media for updates to install. May 31, 2001 (10.0) Word, Excel, Outlook, PowerPoint, Access, Publisher, FrontPage, Small Business Tools Last version to support, and. Improved support for working in user accounts without administrative privileges on and. October 21, 2003 (11.0) Word, Excel, Outlook, PowerPoint, Publisher, Access, InfoPath First version to introduce Windows XP style icons. Last version to support. Last version to have legacy menus. January 30, 2007 (12.0) Word, Excel, PowerPoint, Outlook, Publisher, Access, InfoPath, Communicator, Groove, OneNote, Visio Viewer, OCT Broadly released alongside. First version to use the new with tabbed menus. June 15, 2010 (14.0) Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, InfoPath, SharePoint Workspace, Visio Viewer, OCT, Lync This is the first version to ship in 32-bit and 64-bit. Last version to support and. Version 13.0 was skipped because of the. January 29, 2013 (15.0) Word, Excel, PowerPoint, OneNote, Outlook, Publisher, Access, Lync, Skype for Business, Visio Viewer Lync is replaced with Skype for Business after an update. Remarks 1 Office 2010 Personal was made available for distribution only in Japan. 2 The retail version of Office 2010 Home and Student can be installed on up to three machines in a single household for non-commercial use only. The Product Key Card version only allows a single installation on a single machine. 3 The retail versions of Office 2010 Home and Business and Office 2010 Professional can be installed on two devices including a primary machine, and a portable device such as a laptop, for use by a single user. The Product Key Card version only allows a single installation on a single machine. 4 On February 1, 2012, Office 2010 University replaced the previous Office 2010 Professional Academic edition in an effort to curtail fraudulent product use. 5 Office 2010 Professional Plus is only available for Volume License customers. The retail version is offered through. 6 The Office Customization Tool is used to customize the installation of Office by creating a (.MSP) file, and replaces the Custom Installation Wizard and Custom Deployment Wizard included in 2003 and earlier versions of the Office Resource Kit. It is only available in Volume License editions. Microsoft Office 2013 [ ] Comparison of Office 2013 suites As an individual product Traditional editions subscriptions Office RT Home & Student Home & Business Standard Professional Professional Plus Personal Home University Small Business Premium ProPlus Enterprise Availability Varies,,, Maximum users 1 1 1 1 As licensed 1 As licensed 1 all users in one household 1 10 25 Unlimited Devices per user 1 1 1 1 As licensed 1 As licensed 1 computer and 1 mobile 5 shared among all users 2 computers and 2 mobiles 5 5 5 Commercial use allowed? 1 The do not include all of the functionality provided by other versions of Office. 2 Commercial use of Office RT is allowed through volume licensing or business subscriptions to Office 365. 3 are also available. 4 InfoPath was initially part of Office 365 Small Business Premium. However, it no longer is. Microsoft Office 2016 [ ] As with previous versions, Office 2016 is made available in several distinct editions aimed towards different markets. All traditional editions of Microsoft Office 2016 contain,, and and are licensed for use on one computer. Five traditional editions of Office 2016 were released for Windows: • Home & Student: This retail suite includes the core applications only. • Home & Business: This retail suite includes the core applications and. • Standard: This suite, only available through channels, includes the core applications, as well as Outlook and. • Professional: This retail suite includes the core applications, as well as Outlook, Publisher and. • Professional Plus: This suite, only available through volume licensing channels, includes the core applications, as well as Outlook, Publisher, Access and. Three traditional editions of Office 2016 were released for Mac: • Home & Student: This retail suite includes the core applications only. • Home & Business: This retail suite includes the core applications and Outlook. • Standard: This suite, only available through channels, includes the core applications and Outlook. Mac versions [ ] Release date Title Contents Notes January 23, 1990 Office 1 Word 1, etc. August 1, 1990 Office 1.1 Word 3, etc. 1992 Office 2 Word 4, etc. 1993 Office 3 Word 5, Excel 4, PowerPoint 3, etc. 1994 Office 4.2 Word 6, Excel 5, PowerPoint 4, etc. 1994 Office 4.2.1 Word 6, Excel 5, PowerPoint 4, etc. First release designed for the, final release for 68K March 15, 1998 (8.0) Word, Excel, PowerPoint 98 October 11, 2000 (9.0 Word, Excel, PowerPoint and Entourage 2001 final release for Mac OS 9, latest update 9.0.6. November 19, 2001 (10.0) Word, Excel, PowerPoint, Entourage X first release for Mac OS X, latest update 10.1.9 February 12, 2004 (11.0) Word, Excel, PowerPoint, Entourage 2004 latest update 11.6.4 January 15, 2008 (12.0) Word, Excel, PowerPoint, Entourage 2008 the first release that runs natively on both PPC and Intel without the use of the Rosetta emulation layer, latest update 12.3.0. Does NOT support VBA macros. October 26, 2010 (14.0) Word, Excel, PowerPoint, Outlook 2011 first release for Intel only, latest update 14.1.2. Support for VBA re-instated to this version. July 09, 2015 (16.0) Word, Excel, PowerPoint, Outlook, OneNote 2016 Released on macOS on 9 July 2015, Microsoft added integration with Mac capabilities such as Multi-Touch, Full Screen, and Retina optimization with a focus on cloud-connected capability. • Da Costa, Andre (November 23, 2015).. Retrieved July 22, 2016. November 19, 1990. • Johnston, Stuart J. (October 1, 1990).. March 4, 1991. July 8, 1991. June 15, 2010. Retrieved 26 July 2016. • • Microsoft Word for Windows 95 - Step by step.. • Microsoft Excel for Windows 95 - Step by step.. • Microsoft PowerPoint for Windows 95 - Step by step.. 21 June 2002. Archived from on 21 June 2002. Retrieved 9 June 2013. 5 February 2007. Retrieved 14 June 2013. • Running Microsoft Access for Windows 95.. • Microsoft Bookshelf for Windows 95. Microsoft Press. August 1995.. February 1, 2000. Archived from on February 26, 2000. Retrieved April 28, 2011. Internet Archive: Microsoft. Archived from on 17 November 2000. Retrieved 14 June 2012. Microsoft Japan (in Japanese). Internet Archive: Microsoft Japan. Archived from on 18 February 2007. Retrieved 14 June 2012. Archived from on October 1, 2011. Retrieved December 13, 2012. Archived from on February 18, 2010. Retrieved November 10, 2016. Archived from on February 18, 2010. Retrieved November 10, 2016. October 22, 2012. Retrieved November 10, 2016. Office Support.. Archived from on June 19, 2010. Retrieved February 11, 2017. Office Support.. Archived from on June 25, 2010. Retrieved February 11, 2017. Office Support.. Archived from on June 12, 2010. Retrieved February 11, 2017. Office Support.. Archived from on February 5, 2012. Retrieved February 11, 2017. Office Support.. Archived from on June 16, 2010. Retrieved February 11, 2017. • ^ (June 29, 2010).... Retrieved February 11, 2017. Office Support.. Archived from on June 19, 2010. Retrieved February 11, 2017. • (February 10, 2012).... Retrieved February 11, 2017. Office Support.. Archived from on June 25, 2010. Retrieved February 11, 2017. Office Professional Plus 2010 is available through Volume Licensing only. • (April 22, 2010).... Archived from on June 29, 2010. Retrieved February 11, 2017. May 15, 2015. Retrieved February 11, 2017. The OCT is available only with volume licensed versions of Office 2010 and the 2007 Office system. To determine whether an Office 2010 installation is a volume licensed version, check the Office 2010 installation disk to see whether it contains a folder named Admin. If the Admin folder exists, the disk is a volume license edition. • ^ Paul Thurrott (September 17, 2012).. Retrieved November 21, 2012. Retrieved January 29, 2013. Retrieved January 29, 2013. Retrieved January 9, 2013. Office 365 Blog. Retrieved March 16, 2014. Office 365 Portal. Retrieved February 3, 2013. Retrieved January 10, 2013. • ^ Paul Thurrott (July 16, 2012).. Retrieved November 21, 2012. Retrieved November 21, 2012. Retrieved October 27, 2012. • Arar, Yardena Arar (February 27, 2013).... Retrieved July 24, 2014. • Thurrott, Paul (May 8, 2013).. SuperSite for Windows.. Retrieved July 24, 2014. Retrieved July 24, 2014. Retrieved 2 October 2015. Retrieved 2 October 2015. Retrieved 2 October 2015.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |