Guenter Haslinger
asked on
Excel diagram with 2 y-axis
Hello
Which property has to be set to avoid overlapping of the green data bar,
blue and red data are displayed on the left y-axis, the green one is
displayed wit the right y-axis. I want to see the 3 data bar side by side
without overlapping.
thx
günter
EXE-two-y-axes.xlsx
Which property has to be set to avoid overlapping of the green data bar,
blue and red data are displayed on the left y-axis, the green one is
displayed wit the right y-axis. I want to see the 3 data bar side by side
without overlapping.
thx
günter
EXE-two-y-axes.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes and NO
It works on series point 1, 2 and 4, but it doesn't on 3 and 5 ???
It seems that it works on the series points where the green bar is
the largest ............
It works on series point 1, 2 and 4, but it doesn't on 3 and 5 ???
It seems that it works on the series points where the green bar is
the largest ............
ASKER
It works ... after changing the gap on the blue AND green AND red series,
I don't know the rules, but after MANY changes (a little more, a little less) it works ....
I don't know the rules, but after MANY changes (a little more, a little less) it works ....
While formatting the Green Bars Data series, select the Primary Axis, for Plot series on, to see if you get the desired output.
Does that help?