Forum Discussion
Charticulator custom Gantt Chart
Hello,
I would like to create the following Gantt Chart using the Charticulator tool:https://charticulator.com/app/index.html
I have the following sample data:
| Project | Start Date | End Date | Milestone Date | Milestone Status | Resource |
| Project 1 | 10.03.2022 | 24.09.2022 | 13.04.2022 | Done | Resource 1 |
| Project 2 | 10.01.2022 | 24.10.2022 | 13.05.2022 | Not Done | Resource 2 |
| Project 3 | 17.05.2022 | 24.11.2022 | 13.06.2022 | Late | Resource 1 |
| Project 4 | 21.01.2022 | 24.01.2023 | 13.07.2022 | Not Done | Resource 2 |
| Project 5 | 25.06.2022 | 28.11.2022 | 13.08.2022 | Done | Resource 2 |
Is that even possible?
Thank you!
4 Replies
Your sample data doesn't match the picture. The picture suggests that project 1 was put on hiatus and then restarted?
Hi lbendlin , Thanks for noticing, that was a design misunderstanding. I fixed the image.
Still doesn't match. Your Project 1 shows three milestones in the picture but only one in the sample data.
You will need separate data points for Project Start/Project End and Milestones. For example:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKz0pNLlEwVNJRMjTQMzDWMzIwMgJyjEz0DCxhHENjPQMTGMclPy8VSAWlFueXFiWnArXG6iAMMoIaZIhkEJCPZJApjOOXX6KAbpgRimHGIC3mSFpAhhkiG2YG4/gkluBxlQlIryGqqyAcY6hB5sS7yhSk3xTJbiMLNFdZ4AoroEGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Project = _t, #"Start Date" = _t, #"End Date" = _t, #"Milestone Date" = _t, #"Milestone Status" = _t, Resource = _t]), #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Project", "Resource", "Milestone Status"}, "Attribute", "Value") in #"Unpivoted Other Columns"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
