{"id":4184,"date":"2021-05-17T11:00:00","date_gmt":"2021-05-17T15:00:00","guid":{"rendered":"http:\/\/exceltheatre.com\/blog\/?p=4184"},"modified":"2022-12-04T13:57:53","modified_gmt":"2022-12-04T18:57:53","slug":"excel-dashboard-video-project-gantt-chart","status":"publish","type":"post","link":"https:\/\/exceltheatre.com\/blog\/archives\/2021\/05\/17\/excel-dashboard-video-project-gantt-chart\/","title":{"rendered":"Excel Dashboard Video Project Gantt Chart"},"content":{"rendered":"\n<p>Chandoo started a new Excel series on his blog &#8212; How to create a fully interactive Project Dashboard with Excel. <\/p>\n\n\n\n<p>In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming. <\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">Video: Project Gantt Chart in Excel<\/h3>\n\n\n\n<p>To follow along with the video, <a href=\"https:\/\/chandoo.org\/wp\/interactive-project-dashboard-with-excel\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">go to Chandoo&#8217;s site and download the sample files<\/a>. The video timeline is below the video.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Make an awesome Project Management Dashboard with Excel (Free download ~ Part 1)\" width=\"840\" height=\"473\" src=\"https:\/\/www.youtube.com\/embed\/FXnyKU6xZeI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Video Timeline<\/h3>\n\n\n\n<p>00:00 &#8211; Introduction to Wendy&#8217;s PM Dashboard Problem<br>00:42 &#8211; Overview of the Gantt Chart<br>01:59 &#8211; Person &amp; Activity data setup<br>02:40 &#8211; Calculation worksheet<br>04:20 &#8211; Gantt chart sheet setup<br>06:24 &#8211; Displaying Gantt with Conditional Formatting<br>07:53 &#8211; Filling missing columns with lookups &amp; more CF rules<br>09:06 &#8211; Highlighting the current date column<br>10:03 &#8211; Making the Gantt interactive<br>10:48 &#8211; Next steps for the PM Dashboard<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">More Excel Dashboard Tips<\/h3>\n\n\n\n<p>For more Excel dashboard tips and videos, go to <a rel=\"noreferrer noopener\" href=\"https:\/\/www.contextures.com\/exceldashboardtips.html\" target=\"_blank\">the Create a Better Excel Dashboard page on my Contextures website<\/a>.<\/p>\n\n\n\n<p>There&#8217;s also a <a href=\"https:\/\/www.contextures.com\/excelganttchartprojectplan.html\" target=\"_blank\" rel=\"noreferrer noopener\">Gantt chart example on my Contextures site<\/a>, with a short video that shows how to track a simple business project.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.contextures.com\/images\/dashboards\/chartclutter02.png\" alt=\"\"\/><figcaption>Keep dashboard charts clear and simple<\/figcaption><\/figure>\n\n\n\n<p>_____________________<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Chandoo started a new Excel series on his blog &#8212; How to create a fully interactive Project Dashboard with Excel. In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-4184","post","type-post","status-publish","format-standard","hentry","category-excel-videos"],"_links":{"self":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/comments?post=4184"}],"version-history":[{"count":3,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4184\/revisions"}],"predecessor-version":[{"id":4432,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/posts\/4184\/revisions\/4432"}],"wp:attachment":[{"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/media?parent=4184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/categories?post=4184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exceltheatre.com\/blog\/wp-json\/wp\/v2\/tags?post=4184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}