Wasn't too sure how to ask this question in a search. Apologies if this has been covered before.
I have a bar chart that groups 3 values by month. Each of these 3 values has a target for each month. When grouping these together, the bars are side by side (what I wanted) but the target points are stacked vertically above the middle value for every month (not what I wanted)
Is it possible to change it so that the target point for the relating value is in line with its correct bar?
Below is an example of what I mean. The top is how it currently looks and the bottom is what I'm trying to achieve.
Thanks for that. I had already considered using 4 charts that overlapped each other but knew I would run into issues as some months would have no target data and could throw the charts out individually.
Open to suggestions for displaying the data differently too.