XY Chart -> Comparison chart by year

hi, I want to compare the values of 2022 and 2023 in one bar chart.

this is my data source from DB. but When I create a chart as listed, it becomes like the picture above.

This is the comparison chart I want. I would like to know how to change it to look like this picture.

thanks for reading!

2022 and 2023 data points need to be together in the same 'row'

I want to too. Is it possible to create it using queries?

You could do something like this:

SELECT t1.Date, t1.Value AS Value2022, t2.Value AS Value2023
FROM yourTableName t1
JOIN yourTableName t2 ON t1.Date = t2.Date
WHERE YEAR(t1.Date) = 2022 AND YEAR(t2.Date) = 2023

Change Date to the name of your date column, and change Value to the name of your value column