Can anyone help me with finding a better way to visualize this data. This is data on crimes in London, 'Category' is the blanket name for type of crimes and 'Category2' is their sub category names. There are 11 main categories, and there are 53 sub categories in relation to them.
I have attempted everything, including the coord_flip and resizing the legend but i can not seem to find a way around it. Also, in the legend I can only see 44 sub categories - meaning I am missing 9 from my view. Additionally, the colour scheme for the legend is too similar and it defeats the purpose of having this key as it is difficult to identify what is what.
Please can you help me figure out a way to present this data better