How do I gather and display info for this dashboard widget?

Carroll Wall

Hello Everyone!

I have a dashboard that is tracking the progress of several projects.

My audience had requested a visual representation of where each project is in the PM Phases

Initiation, Planning, Execution, Monitor and Control, Closure

I have created a sheet summary report that shows in words where each is

is but they want something like a progress bar, that advances to show where each is

Something like this. (excuse typo)

I was thinking a simple stacked bar graph would work but my question is how do I collect this?

A series of check boxes? A bunch of sheet summaries? Some sort of metric sheet?

Thanks for your assistance!

Carroll

AravindGP

Hi Carroll,

You can get something like the below image. To get this, assign a value to each phase, in this case, I have kept it as 20 when each phase is complete. You can create a formula to update a value for each phase in each column in your sheet. You will have a column for each phase and a formula to update the value if the phase of the project matches with the phase name in the column.