bar graph overlaping
It is a nightmare when you try to plot a bar graph with secondary axis... everything overlaps and you need to insert invisible data to avoid the overlap... is really complicated and time consuming, please remove that automatic overlapping when you have primary and secondary axis in a bar graph!!!! a simple graph like the attached one took me hours... and is not even perfect... the size of the bars is not exactly the same, etc etc
This is absolutely frustrating. I'm trying to do the same with a pivot chart and have 2 values I want to show for multiple categories, but when I add a secondary axis, the values overlap and becomes completely useless. neither of the values make sense showing as a line graph, because line graphs imply the categories are related by linking the values. Please please please fix this.