Diagram colour switch

Hi, I’d like to give the y-axis colours instead of the x-axis. I know that I can switch the axes but I need the months on the x-axis and the seasons on the y-axis. Does anybody know a solution?

Thanks so much! Best regards.

Hi @Jana_Elkmann,

The solution is one click away! You need to use the button in the upper-left corner of the datasheet and the axes will switch places. Here’s a quick screen recording showing how it works: https://recordit.co/xqgLTAOCJG

Hey @Ketija_Riteniece,

thank you so much for your answer. Unfortunately that isn’t the solution that I need. I need the colour fields to be on the left side (on the y axis). So that e.g. “spring” is all green from January to December), or Summer is all yellow. I’m gonna add a picture of how it should look like.
Thank you so much!

I’m afraid it won’t be possible in this chart type. I can only suggest creating such a visualization manually, by creating circle shapes (found under the Add Shape button in the left sidebar), grouping them together, then placing manually in rows and adding the right text fields next to them.

Please, let me know if you need any assistance with this!

1 Like