Found it finally, thank you Felipe for giving me Ideas to look for.
After googling around a bit more, I found out that it apparently convert it to UTC time by standard. Looking into the documentation I found the option to change it to false. https://apexcharts.com/docs/options/xaxis/
After changing it to false it used the local timezone set in the project and database.
