XL Charts: Secondary Y-Axis

  • 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.

  • Re: XL Charts: Secondary Y-Axis

    Thanks for the response!

    I should've been clearer from the outset, I would like the bars to be displayed side-by-side (similar to the "Change Chart Type" icon), not one on top of the other.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!