Wondering if anyone knows how to do this.
I have 5 metrics and targets for each metric. So AB, CD, Ef, GH, IJ.
I also have these numbers spanned over 7 days for the week.
Firthermore I have one additional metric as a line graph on a second axis so you can compare how the 5 influence the impact one.
Currently when in a bar chart it looks as such:
ABCDEFGHIJ Monday | ABCDEFGHIJ Tuesday... and so on
I know I can increase spacing bewteen but that puts spaces inbetween all columns and what i want is as such:
AB CD EF GH IJ Monday | AB CD EF GH IJ Tuesday | .....
So I want the metric and target grouped each day and seperate from other metrics but have all metrics under each day, hope that makes sense.
Thanks!!