You are not dreaming! You can easily create a Gantt Chart directly in Excel using a FREE app and also publish it to Power BI!
We will need:
Project Online account
Projects data
Excel 2013 or 2016
Gantt Chart for Excel App
Let’s create our Gantt Chart of projects from Project Online and publish it to Power BI.
Open Excel
Create a New Query – From Other Sources – From OData Feed
![](https://static.wixstatic.com/media/db3ec0_8cffa82dedf4465085cbe5567ad93459~mv2.png/v1/fill/w_447,h_567,al_c,q_85,enc_auto/db3ec0_8cffa82dedf4465085cbe5567ad93459~mv2.png)
Use your Project Online OData Feed URL
![](https://static.wixstatic.com/media/db3ec0_50c20a093e5449408e1c9610f9e429bc~mv2.png/v1/fill/w_705,h_251,al_c,q_85,enc_auto/db3ec0_50c20a093e5449408e1c9610f9e429bc~mv2.png)
Select on the Projects table
Click on Edit
![](https://static.wixstatic.com/media/db3ec0_4b21d6719abd47988b7a2d8d6675aa8c~mv2.png/v1/fill/w_569,h_453,al_c,q_85,enc_auto/db3ec0_4b21d6719abd47988b7a2d8d6675aa8c~mv2.png)
Select at least the following fields:
– ProjectName
– ProjectStartDate
– ProjectFinishDate
Click on Close & Load
Insert a New PivotTable using the workbook’s Data Model
![](https://static.wixstatic.com/media/db3ec0_25d1bbea4fae49aca6d4f38f30723f54~mv2.png/v1/fill/w_414,h_433,al_c,q_85,enc_auto/db3ec0_25d1bbea4fae49aca6d4f38f30723f54~mv2.png)
Add our columns in the following order
– ProjectName
– ProjectStartDate
– ProjectFinishDate
![](https://static.wixstatic.com/media/db3ec0_f8fd6a36b59f49f289554a6ed7f45476~mv2.png/v1/fill/w_470,h_378,al_c,q_85,enc_auto/db3ec0_f8fd6a36b59f49f289554a6ed7f45476~mv2.png)
Add the Office App “Gantt Chart for Excel” under the Insert tab, My Add-ins button
In case you don’t have it already, just install it from the Store in See All
![](https://static.wixstatic.com/media/db3ec0_946ff189b04445fd850ecbed600c83d4~mv2.png/v1/fill/w_685,h_517,al_c,q_85,enc_auto/db3ec0_946ff189b04445fd850ecbed600c83d4~mv2.png)
Create your layout
Then click on “Select Table“
![](https://static.wixstatic.com/media/db3ec0_8e19ff5b1b9e457c83835b1f389d2a92~mv2.png/v1/fill/w_681,h_405,al_c,q_85,enc_auto/db3ec0_8e19ff5b1b9e457c83835b1f389d2a92~mv2.png)
Select the range table
Click on OK.
![](https://static.wixstatic.com/media/db3ec0_9d730d8b18c34e49b6d8cccd94badc4c~mv2.png/v1/fill/w_611,h_402,al_c,q_85,enc_auto/db3ec0_9d730d8b18c34e49b6d8cccd94badc4c~mv2.png)
And that is it! J
You have now a cool Gantt Chart in Excel showing Project Online data
![](https://static.wixstatic.com/media/db3ec0_eb71db4de6de46f0a207b9d564ec79f8~mv2.png/v1/fill/w_669,h_523,al_c,q_85,enc_auto/db3ec0_eb71db4de6de46f0a207b9d564ec79f8~mv2.png)
Upload your file to OneDrive or SharePoint
Now you can access it directly in the browser!
![](https://static.wixstatic.com/media/db3ec0_163e4a7b3ea54275ad4cda28caf6fde3~mv2.png/v1/fill/w_715,h_464,al_c,q_85,enc_auto/db3ec0_163e4a7b3ea54275ad4cda28caf6fde3~mv2.png)
You can also import it into Power BI
![](https://static.wixstatic.com/media/db3ec0_c38738201c814ed093e7772ab0aed659~mv2.png/v1/fill/w_945,h_468,al_c,q_90,enc_auto/db3ec0_c38738201c814ed093e7772ab0aed659~mv2.png)
That is our Gantt Chart in Power BI
![](https://static.wixstatic.com/media/db3ec0_6d1cfef611d54051a42a4f4a22844673~mv2.png/v1/fill/w_945,h_647,al_c,q_90,enc_auto/db3ec0_6d1cfef611d54051a42a4f4a22844673~mv2.png)
Hope you like it! J
Comentarios