Forum Discussion
Visualize dates on a chart
Hello there,
I'm trying to visualize this kind of work data. Simple visuals like Columns or Line charts have the below limitations for me.
1. X axis is the dates, and Y axis has count of Activities whereas I want the activity itself. I can't possibly have dozens of legends in a chart for all project activities. The resulting graph is bad to look at because the count is usually 1 for each activity.
2. X axis has only one kind of date. I can't compare with different kinds of dates (planned date vs actual date) in a single visual.
Any suggestion for a good representation of such kind of data.
| Project Activity | Activity Details | Planned Submission to A | Planned Submission to B | Actual Submission to A | Actual Submission to B | Status |
| Activity 1 | Milestone 1 | 01-Feb | 03-Feb | 06-Feb | 08-Feb | Submitted |
| Activity 2 | Milestone 1 | 28-Feb | 02-Mar | 05-Mar | 07-Mar | Submitted |
| Activity 3 | Milestone 1 | 03-Mar | 05-Mar | 08-Mar | 10-Mar | Ongoing |
| Activity 4 | Milestone 1 | 05-Mar | 07-Mar | Ongoing | ||
| Activity 5 | Milestone 2 | 08-Mar | 10-Mar | Not Submitted | ||
| Activity 6 | Milestone 3 | 17-Mar | 19-Mar | Not Submitted | ||
| Activity 7 | Milestone 3 | 18-Mar | 20-Mar | Not Submitted | ||
| Activity 8 | Milestone 3 | 19-Mar | 21-Mar | Not Submitted | ||
| Activity 9 | Milestone 3 | 20-Mar | 22-Mar | Not Submitted |
2 Replies
Anonymous , check if Charticulator can help or Matrix visual you can try
Charticulator example
Charticulator Part 2 - Scatter with Shapes: https://www.youtube.com/watch?v=QIPsv5hNbqI
