Visualize dates on a chart

[TinyElephant]

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

[amitchandak]

@TinyElephant , 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

[TinyElephant]

It doesn't seem to work with Charticulator. Isn't there any sort of Gantt chart that only needs a date not both the start and end date?