This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Now simply click the first start date in your task table and drag your mouse down to the last start date. To the right of the Series values field you will see an icon with an arrow pointing up.Ĭlick on the icon and Excel will open a smaller Edit Series window. This is where you will enter your Task start dates. Staying in the Edit Series window, move down to Series value. Click and place your cursor in the empty field under the title Series name, then click on the column header that reads Start Date in your table. First, we need to name the data (Series) we will be entering. Click on the Add button to bring up Excel's Edit Series window where you will begin adding the task data to your Gantt chart. On the left side of Excel's Data Source window, you will see a table named Legend Entries (Series). Right-click the white chart space and click Select Data to bring up Excel's Select Data Source window. Then select Stacked Bar, which will insert a large blank white chart space onto your Excel worksheet (do not select 100% Stacked Bar).ģ. Add the start dates of your tasks to the Gantt chart. In the Charts section of the ribbon, drop down the Bar Chart selection menu. Within the same worksheet that your Excel table is on, click in any blank cell.įrom the Excel ribbon, select the INSERT tab. 2. Begin making your Excel Gantt by setting it up as a Stacked Bar Chart. In this tutorial, we will convert this table into an Excel Gantt chart and then into a PowerPoint Gantt chart. Make sure to include a brief description for each task, and then sort them in order, by placing the earliest start date first and the latest date last, as shown in the image below. In Excel 2013, 20, enter your data by listing the Start Date and Finish Date of each task, along with their duration (count of days required to complete that task). These will be called project tasks and they will form the basis of your Gantt chart. This folder keeps your presentation across all of your iOS devices.Download Excel Gantt chart template How to make a Gantt chart in Excel 1. List your project schedule in an Excel table.īreak down the entire project into chunks of work, or phases. The default location Keynote chooses is the Keynote folder on your iCloud. To choose where to save the presentation, click the arrow next to the Where pop-up menu, then choose a location in the dialog. Add tags if you want to in the field below.Ĩ. mp4 and it is going to work on any device and software.ħ. If you want to use another size, click Custom. We suggest 720p for smaller screens, like phones and tablets, and 1080p for desktop, since the technology advanced so much lately.ĥ. That’s the size of the horizontal in pixels. There are two default sizes – 720p and 1080p. On the Resolution drop-down menu, you can choose the resolution the video is going to be exported in. These timings apply only to click events.Ĥ. If you choose Self-Playing you can enter the time you want the next slide or build to advance. If you want the slides to advance by themselves, you can leave the option Self-Playing.ģ. If you recorded narration, you can click the Playback pop-up menu, then choose Slideshow Recording. Click on the service menu on top of your screen File > Export To > MovieĢ. Its size is 30 MB and includes text with a non-system font, animations (build and transitions), video, sound, and interactive buttons.ġ. So, this option is good only if you want to send an editable file with only pictures and text that is with system font for both computers receiving the file.īelow you can see a comparison of advantages and disadvantages when exporting a Keynote file to another file format.įor this purpose, we have exported the same Keynote file in all of the formats. The formatting of the elements is not transferred through, the font needs to be sent and installed additionally and some of the animations won’t work. Of course, a PowerPoint file can be opened only by the PowerPoint software and there are lots of problems. Its minus is that it cannot be viewed on mobile devices and its file size is big. The master of them all is the HTML document because with an HTML you can be sure that every desktop can open your presentation correctly and it can be like an interactive webpage with animations, transitions, the right font, video, and sound. However, animations will be there and you can even add narration. If you export the presentation to a video the file size is going to be much higher. PDF saves the slides as they were intended to look but cannot save animations. This can be achieved when exporting to PDF, HTML, or Video.
0 Comments
Leave a Reply. |