Hi!
I would like to remove the gaps in my clustered column chart. The gaps represent the empty cells in the source data.
I ended up using a multi-level category chart (category: time interval, subcategory: countries) to remove the gaps. However, i would like for the subcategory (countries) labels to not show on the horizontal axis. How do i fix this? It seems that excel does not allow to edit independently the categories and subcategories on the axis.
I didn't find a proper solution to fix my problem on google, so i thought i could try here.
gaps1.JPG
gaps2.JPG
Bookmarks