Gantt chart. Then add the "durations

shiyabulseo@gam

Cked bar chart highlighted in green below. This will insert a blank chart into your spreadsheet. Add start date data Hover your mouse over the empty Excel chart and right-click. Then left click on “select data”. The "select source" data window will be displayed. First click the name of the empty series in the form field, and then click the table cell that says "Start Date." ADVERTISEMENT Click the icon at the end of the series "values" field. The icon is a small spreadsheet with a red arrow. This will open the "edit series" window. Click the first start date and drag the mouse to the last start date. After highlighting the correct dates, click the icon


at the bottom of the "edit series" form. The window will close and Chinese Australia Phone Number List the previous window will reopen. Select OK. Your start dates are now on the Gantt chart. Then add the "durations" column using the same procedure as adding start dates. Under "Subtitle Entries," click "Add." Click the empty series name, click the form field, and then click the table cell that says "duration." Once the durations are highlighted, click the icon at the bottom of the "edit series" form. The window will close and the previous window will reopen. Select OK. Your durations are now on your Gantt chart. Click OK twice. Format your Gantt chart What you have now is a stacked bar





chart. Start dates are blue and durations are orange. Please note that your tasks are in reverse order. To fix this, click on the task list to select it, then right-click on the list and choose "format axis." Select the "categories in reverse order" checkbox and close. To give more space to the Gantt chart, remove the heading "start date", duration on the right. Select it with the mouse and click delete. Hides the blue parts of each bar. Clicking on the blue part of any bar will select them all. Then right click and choose “format data series”. Click Fill and select "unfilled." Click the border color and select "no line." Then you'll just need to delete the empty w