Regrettably, Microsoft Excel does not have a built-in Gantt chart template as an option. However, you can quickly create a Gantt chart in Excel by using the bar graph functionality and a bit of formatting. Please follow the below steps closely and you will make a simple Gantt chart in under 3 minutes. Excel Calendar PRO is an extension of Vertex42's free Excel Calendar. It provides a few additional features, such as mini calendars and a button to automatically create a 12-month calendar in a new workbook, beginning with the month of your choice.
Create a calendar. On the File menu, click New. Click BUILT-IN, and then click Calendars. (In Publisher 2010, click Calendars under Most Popular.). Click the calendar that you want to create. Calendars are categorized by type (for example, Full Page or Wallet Size). In the task pane, click the options that you want, such as color or font scheme, page orientation, and whether to show one month or one year per calendar page (to change the month that the calendar starts on, click Set Calendar Dates).
To include a schedule of events in your calendar, select the Include schedule of events check box. Create a calendar. On the File menu, click New.
In the Publication Types list, click Calendars. Under Calendars, click the type of calendar that you want to create (for example, Full Page or Wallet Size), and then click the design that you want. In the Customize task pane, click the options that you want, such as color or font scheme. In the Calendar Options task pane, click to select the page orientation, and whether to show one month or one year per calendar page (to change the month that the calendar starts on, click Set Calendar Dates).
To include a schedule of events in your calendar, select the Include schedule of events check box.