Graphing 2 data series, primary and secondary axis, overlap property

[DashboardNovice]

Hello everybody. In the attached file, I am graphing the table showing compound interest starting in cell F12. The values from B13:B24 are graphed as Series 3 in green as a line.

For the compound interest data, I have "Balance" on the primary axis and "Interest" on the secondary axis. I want to overlap these so that the columns for the Balances in G13:G24 are in front, and the Interest in red bars are behind. I know I can do this if I switch around columns G and H, but I really need G and H to remain in their current order.

Is there a way around this?

 

[Debraj]

http://social.technet.microsoft.com...ph-bring-series-to-front-of-graph?forum=excel

There are certain cases where Excel will not let you change the layering. One of them is when there are different types of series in the same chart. For example, with a Line and a Column series, the line is always in front of the column.
Another case is when there are series on the secondary and the primary axis. For example, a column chart on the secondary axis is always shown in front of a column chart on the primary axis.

http://www.pcreview.co.uk/forums/ch...and-secondary-axes-excel-charts-t1788502.html

I don't believe you can change the order of primary/secondary data. You
can only change the order within primary or secondary.
Although some combinations of charts do automatically reverse the order.
An area chart on the secondary axis is plotted behind bars/lines on the
primary. Maybe you could revise your chart to take advantage of this.

 

[NARAYANK991]

Hi ,

I do not know what this chart is supposed to show , since the data is generated by an equation , and both the interest and the balance will always be in proportion.

In case you want both of the columns to be visible , you can ensure that by a judicious choice of the axes !

See if this is what you want.

Narayan

 

[DashboardNovice]

Hi ,

I do not know what this chart is supposed to show , since the data is generated by an equation , and both the interest and the balance will always be in proportion.

In case you want both of the columns to be visible , you can ensure that by a judicious choice of the axes !

See if this is what you want.

Narayan

Yes, that is exactly what I was trying to do. At first I couldn't replicate what you did, but now I've got it. It's just a matter of using Fixed Values on the primary and secondary axis. My max value on the primary was a little too high, which shrunk the columns bars plotted on that axis. So to magnify those bars, I just had to lower the Max value for that primary Y axis.

Thank you.