Why the Chart represent / shows the wrong Data?

Question

I create a Template Chart to shows a certain DATA in time of updating:

	08/12/2023	12/12/2023	15/12/2023	19/12/2023	03/01/2024	05/01/2024
ID	X	X	X	X	X	X
B1	-0.1	-0.1	-0.6	0.4	0.0	-1.1
B2	-0.4	0.4	-0.8	-0.2	-0.2	-1.3
B3	-0.2	-0.2	-0.7	0.0	-0.4	-1.5
B4	0.3	0.5	1.3	-0.3	1.6	1.0
B5	0.6	0.9	1.5	0.2	1.8	1.5
H1	0.3	0.5	1.2	0.6	1.8	0.9
H2	-0.4	-0.3	0.5	0.2	1.3	0.5
H3	0.1	0.5	1.2	0.6	1.6	1.3
H4	0.6	0.7	1.1	0.6	1.8	1.3
H5	-0.1	0.4	0.6	0.0	1.0	1.0
H6	0.2	0.2	0.4	-0.8	-0.7	-0.9
H7	-0.2	0.4	0.9	0.5	1.4	1.5
H8	-0.2	0.2	0.3	0.0	1.1	0.3
H9	0.0	-0.8	-0.7	-1.1	-1.2	-2.5
H10	0.1	0.1	-0.6	-1.8	-1.6	-2.3
H11	-0.3	-0.1	-0.6	-0.3	0.3	0.4
H12	-0.1	-0.1	-0.6	-0.5	0.1	-0.1
H13	0.8	0.5	-0.4	-1.0	0.2	1.5
H14	-0.1	-0.3	-0.2	-0.7	-0.5	-0.1
W1	0.2	0.0	-0.1	-0.1	0.2	0.1
W2	-0.5	-0.8	-1.1	-0.8	-1.0	-1.1
W3	-0.2	0.0	-0.6	-1.1	-1.6	-2.2
W4	0.1	0.1	-1.3	-1.5	-2.0	-2.6

Where the maximum Value is -2.6, but the chart shows different data (Attached Chart 1).

1. I Updated the data source, but the Chard does not update (Attached Data Update).
2. Then I created a new chart -> what shows the data correct, but the first one still does NOT updates (Attached Chart 1-2)

How can I be sure that the Chart is updating in continue?

I can send the original EXCEL file.

Answer 1

You may upload file in private message. Then we may have a try on correcting it.