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