How to show a chart (stacked?) of count of each task status + number of late tasks per status
Hello,
I have a typical project schedule sheet with tasks, start/finish dates, etc, and have a Status column with several different levels of task status, which includes several status levels (process steps) in between "not started" and "complete". I also have a check box column marking when a task is late (start and finish dates are past, but status is not "complete"). I would like to include a chart on the dashboard showing the number of each status level, plus the number that are late within each status type. - Obviously, this won't apply for some of the Status levels, like "not started" or "complete", but since we have several other status levels in between, we'd like to see where the late tasks are getting hung up.
How can I create a stacked chart or bar chart showing this?
Thanks!
Best Answer
-
You can create a ew sheet for your graph data. Use a COUNTIF or COUNTIFS formula to complete that sheet from the data in your project schedule and then create a graph from the graph data sheet.
Your aim is to create a new sheet of data that looks something like this:
From that you can create a graph like this:
Using these settings:
Answers
-
You can create a ew sheet for your graph data. Use a COUNTIF or COUNTIFS formula to complete that sheet from the data in your project schedule and then create a graph from the graph data sheet.
Your aim is to create a new sheet of data that looks something like this:
From that you can create a graph like this:
Using these settings:
-
Great - thank you! I'll give it a try. I was thinking in terms of using a report to pull in my data, which didn't work to create the stacked chart, but this makes sense. Thanks for the suggestion.
-
Glad I could help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives