Hi,
I'm trying to present a bar chart with years side by side for specific months.
What I'm trying to show is clients coming in, clients coming out for the same month, ie January and February, for two different years and the balance of the clients represented by a dot, whether it's positive or negative, as you can see in the image below.
Target.png
However, what I currently have is a large space between the different years, and I had to manually change the colour for 2022 and also for the dots (which are plotted on a secondary axis).
Plots.PNG
My questions are:
- What can I do to reduce the gap between the 2021 and 2022 to make them appear side by side (I've tried adjusting size of bars but this puts them all together)?
- How can I make the negative values automatically appear in a different colour but also directly underneath the positive graphs?
- How can I plot the balance of the two and make it vary in terms of colour?
Thanks,
Bookmarks