Hi there,
when rendering a combination chart, apparently a series on a secondary axis is drawn over the top of series on the first axis. Depending on the series types you are using, that may be what you want, or it may not be.
See screenshot attached. Upper graph contains two series in the primary axis drawn as columns, while the secondary axis is one series drawn as a line. The line is drawn over the top of the columns, which is just fine.
Bottom graph however contains two lines in the primary axis, and one column in the secondary axis. Here too, the secondary is drawn over the top of the primary, which is not what I want.
Now I could obviously just swith primary and secondary series, however that will also change the order of the legend. As I'd like that to be the same across both graphs, if I did that, I'd also have to ditch the chart's built-in legend and create a manual legend.
Is there any way to change the draw order so that I can put the secondary series behind the primary, or do I have to go the workaround above?
thanks,
hespora.
Also, while we're at it - is there any way to set a fixed amt. of space for chart axis labels, so that when I align to chart objects horizontally or vertically, their drawing area can be aligned fixed as well?