How to visualize program status
I have recently come on to a large program with many different projects all at various stages. My immediate goal is to consolidate this information and try to visualize it on a dashboard so that we can start to understand where each project is.
A general overview of our project life cycle:
Ideation (V0) —> R&D Planning (V1) —> Development (V2) —> Release (V3) —> Sustaining (V4)
The issue is that projects can live in more than one phase at a time. e.g. some HW R&D scoping (V1) can take place while we finalize the SW requirements (V0).
Ideally, I would like a stacked bar chart with three data sets. The y-axis shows the projects, the x-axis shows the project stages, and the z-axis shows percentage complete within each stage. But I have been unsuccessful in getting this to work. I have tried pulling this data from reports and sheets but I just cannot figure out how to represent it in a chart. I'm starting to realize a stacked chart might not be the best way to represent this data.
Any suggestions on how to get this to work or any better means to visualize this data?
Answers
-
@Daniel Barber
I believe the best alternative is a heat map matrix. List projects on the y-axis, phases on the x-axis, and use color gradients in each cell to show percentage complete. This approach offers a clear, quick view of each project’s status across phases, highlighting overlap and progress effectively.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 412 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives