Multiple values on the same x point without index labels

[061elliven]

Hi!

As has been discussed in many places, if there are many values in the same position in the x-axis, they must be summarized (the first Figure). However, this can be bypassed by indexing the data and putting indices to the legend. After this, summarization doesn't affect the data points and they can be visualized individually (Figure 2). I have indexed the data based on the date, because otherwise with a large dataset only part will be visualised, due to too many values to visualise in the legend (some legend color limitations, if I have understood correctly).

My problem is that I also have different categories, that I should visualize with different legend colors. There may be multiple points for the same category on the same date. However, now the colors are already reserved for the indices, and changing them to category would force me to summarize the data based on category (Figure 3), while I still want to see each point separately. Does anyone have any idea, could there be some other way to bypass this summarization problem without using indices as legend, or some other way to solve my problem?

Some example dataset below. 

Custom.Date.1	Custom.Date.2	Custom.ID	Custom.Category	Custom.Value	Custom.Index No.
2.1.2023	8.14.00	UNIT1	Model1	0.113428	1
2.1.2023	8.31.00	UNIT2	Model2	0.119555	2
2.1.2023	8.14.00	UNIT3	Model1	0.115939	3
2.1.2023	8.14.00	UNIT4	Model2	0.185126	4
2.1.2023	8.14.00	UNIT5	Model2	0.100386	5
2.1.2023	8.31.00	UNIT6	Model2	0.125646	6
2.1.2023	8.31.00	UNIT7	Model1	0.108972	7
2.1.2023	8.31.00	UNIT8	Model2	0.11485	8
2.3.2023	8.32.00	UNIT9	Model1	0.113144	1
2.3.2023	8.49.00	UNIT10	Model2	0.111068	2
2.3.2023	8.15.00	UNIT11	Model1	0.122302	3
2.3.2023	8.32.00	UNIT12	Model1	0.111753	4
2.3.2023	8.49.00	UNIT13	Model2	0.0997352	5
2.3.2023	8.32.00	UNIT14	Model2	0.103873	6
2.3.2023	8.32.00	UNIT15	Model1	0.112922	7
2.3.2023	8.49.00	UNIT16	Model2	0.169596	8
2.3.2023	8.49.00	UNIT17	Model2	0.107185	9
2.3.2023	8.15.00	UNIT18	Model1	0.111467	10
2.3.2023	8.15.00	UNIT19	Model2	0.120943	11
2.3.2023	8.15.00	UNIT20	Model1	0.111139	12
2.8.2023	8.44.00	UNIT21	Model1	0.106877	1
2.8.2023	9.01.00	UNIT22	Model1	0.166383	2
2.8.2023	9.18.00	UNIT23	Model2	0.163812	3
2.8.2023	8.27.00	UNIT24	Model1	0.112142	4
2.8.2023	8.44.00	UNIT25	Model2	0.110081	5
2.8.2023	8.44.00	UNIT26	Model2	0.1035	6
2.8.2023	9.01.00	UNIT27	Model1	0.104857	7
2.8.2023	9.18.00	UNIT28	Model2	0.103138	8
2.8.2023	9.18.00	UNIT29	Model2	0.106173	9
2.8.2023	9.18.00	UNIT30	Model1	0.13739	10
2.8.2023	9.01.00	UNIT31	Model2	0.111661	11
2.8.2023	9.01.00	UNIT32	Model1	0.200433	12
2.8.2023	8.44.00	UNIT33	Model2	0.101894	13