Forum Discussion
dividing lines in column chart?
Hi, I have a column chart where it is not totally obvious where one category ends and the next one begins. So I'd like to just have some lines to divide my categories, is that possible?
What I have:
What I have now: no lines between categories
What I want:
What I'd need: dividing lines between the ctegories
Thanks, Philipp
I would try the clustered technique below, having all the columns touching.
The other option is to try something clever by adding a column into the data at a fixed height.
This can look ugly though.
Or go to Columns -> Layout and set the Space between categories to max and Space between series to min.
Finally there is always the option of small multiple:
3 Replies
- SamWiseOwl
Super User
HI PhilippOtto
I don't believe there is a built in feature.
One thing to try is using overlap to make the grouped columns overlap.
Or using the Insert tab add a shape that is a line between each:
Hi & thanks! I just have the issue, that the number of columns may vary depending on filters, so those line-shapes are often at the wrong place after filtering ☹️
- SamWiseOwl
I would try the clustered technique below, having all the columns touching.
The other option is to try something clever by adding a column into the data at a fixed height.
This can look ugly though.
Or go to Columns -> Layout and set the Space between categories to max and Space between series to min.
Finally there is always the option of small multiple:
