Is it possible to have two bar graphs, for example, on the same chart without the graphs overlapping when one is to be read from a secondary y-axis? If so, how can I do this?
I'm trying to graph financial results over a 5 year period in bar-graph form. One of the bars will represent net profit and the other will represent average profit. Since the magnitude of the numbers is so drastic, a secondary y-axis is needed (for scale). Adding the y-axis to the chart causes the bars to overlap.