Graphic Dashboard widgets
Answers
-
I am trying to create an executive level dashboard - with a bar graph that shows all the projects names on the y- axis, with a single line progression bar that indicates dates as it reached each milestone on the x- axis. Is there a way to achieve this, without showing a Gantt chart report?
-
Greetings -
If all the projects have similar milestones, you could set up a sheet that has each project in the primary column, then use INDEX|MATCH's to pull the milestone dates into a separate column for each milestone. Then if the column has a value, use conditional formatting to fill the cell with a color as if it were the progress bar. Then put the sheet into a report and a report into the dashboard.
I know it's a bit of a hip fake on how to get there but it will accomplish what you are after.
Best,
Hudson
