{"id":1666,"date":"2012-12-05T10:37:32","date_gmt":"2012-12-05T16:37:32","guid":{"rendered":"https:\/\/www.vertex42.com\/blog\/?p=1666"},"modified":"2019-11-26T14:36:25","modified_gmt":"2019-11-26T20:36:25","slug":"creating-a-gantt-chart-with-excel-is-getting-easier","status":"publish","type":"post","link":"https:\/\/www.vertex42.com\/blog\/help\/gantt-chart-help\/creating-a-gantt-chart-with-excel-is-getting-easier.html","title":{"rendered":"Creating a Gantt Chart with Excel is Getting Even Easier"},"content":{"rendered":"<p><a href=\"\/ExcelTemplates\/excel-gantt-chart.html\"><strong>&#9668; Return to the Gantt Chart Template Page<\/strong><\/a><\/p>\n<p>One of the most common requests that I get from users of my <a href=\"\/ExcelTemplates\/excel-gantt-chart.html\"><strong>Gantt Chart<\/strong><\/a> template is the ability to <strong>switch the view between daily, weekly, and monthly<\/strong>. The new version of the template provides a solution that is very easy to use. All you do is select the view you want from a drop-down box.<\/p>\n<p>Check out the images below to see the new view-control features:<\/p>\n<h3>Version 2.3 for Excel 2003 (.xls)<\/h3>\n<div style=\"width: 578px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" alt=\"Gantt Chart Template version 2.3 XLS\" src=\"\/\/cdn.vertex42.com\/Images\/products\/GanttChartTemplate_2-3-1_xls.gif\" title=\"Gantt Chart Template version 2.3 XLS\" width=\"568\" height=\"319\" \/><p class=\"wp-caption-text\">Screenshots of the new view controls in Gantt Chart Template PRO, version 2.3 for Excel 2003 (XLS)<\/p><\/div>\n<h3>Version 2.3 for Excel 2010 (.xlsx)<\/h3>\n<div style=\"width: 579px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" alt=\"Gantt Chart Template version 2.3 XLSX\" src=\"\/\/cdn.vertex42.com\/Images\/products\/GanttChartTemplate_2-3-1_xlsx.gif\" title=\"Gantt Chart Template version 2.3 XLSX\" width=\"569\" height=\"339\" \/><p class=\"wp-caption-text\">Screenshots of the new view controls for Gantt Chart Template PRO version 2.3 for Excel 2010 (XLSX)<\/p><\/div>\n<p>Note: Both files (.xls and .xlsx) will work in Excel 2007+. When using Excel 2007, 2010, or 2013, the .xls file will open in Compatibility Mode.<\/p>\n<h2>New Color-Coding Feature in the XLSX Version<\/h2>\n<p>The main thing that the XLSX version adds that is not possible to do with Excel 2003 (without adding VBA) is automated color-coding of the bars of the gantt chart.<\/p>\n<p>You will see in the above screenshots that I've added a \"Color\" column where you can enter a color code to choose the color for the bar (\"r\" = red, \"g\" = green, etc.).<\/p>\n<p>By using a formula in the Color column, you can automatically color code based on project lead and\/or urgency. Example formulas for doing that are included in the spreadsheet.<\/p>\n<h2>Feedback<\/h2>\n<p>Please give feedback regarding this new version of Gantt Chart Template Pro. After all, feedback is what led to these new features in the first place.<\/p>\n<p>Update 2\/12\/2014: In response to a question about the Google Sheets version of Gantt Chart Template Pro, I have posted a screenshot below. This link to the Google Sheets version is included as a bonus with the purchase.<\/p>\n<p><a href=\"https:\/\/cdn.vertex42.com\/ExcelTemplates\/Images\/ganttchart\/gantt-chart-for-google-sheets.png\" data-rel=\"prettyphoto noopener noreferrer\" target=\"_blank\"><img decoding=\"async\" src=\"\/\/cdn.vertex42.com\/ExcelTemplates\/Images\/ganttchart\/gantt-chart-for-google-sheets.png\" alt=\"Gantt Chart for Google Sheets\" style=\"max-width:500px;\"><br \/>View Larger Image<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The request to be able to switch between daily, weekly, and monthly views has been added to the next version of Gantt Chart Template Pro.<\/p>\n","protected":false},"author":3,"featured_media":1701,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[58],"tags":[],"class_list":{"0":"post-1666","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-gantt-chart-help"},"_links":{"self":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/1666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/comments?post=1666"}],"version-history":[{"count":0,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/posts\/1666\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/media\/1701"}],"wp:attachment":[{"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/media?parent=1666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/categories?post=1666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vertex42.com\/blog\/wp-json\/wp\/v2\/tags?post=1666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}