How to swap between to verticals axis

Hello Everyone,
I have and excel chart with 2 vertical axis.
The problem is each axis is far from the data concerning it.
How can I swap between the 2 vertical axis?

In the example attached, There 2 axis, 1. for Big example - there budget is measured in Milion Dollars.
2. For small companies, there budget is measured in 100,000 Dollars.

The chart turn out to be that the histograms of the big companies is near the chart of small companies.
How to switch between the 2 vertical axis so the big companies will be near the axis of big companies and the axis of small companies will be near the small companies?

Hi, your file still refers to your real data in file:
your name and familyname\Documents\Region Last 10 Years\[Regions Last 10 Years.xlsx]

We obvoiusly do not have access to it.

I focused on Sheet2 in your file (the one that opens automatically when downloaded).

1) sort all rows this way the data shall be presented on horizontal axis - I sorted descending on the actual budget so the largest will be presented leftmost, the smallest rightmost
2) for "large companies" series use data only for large values (M$). For instance if a threshold Big/Small is at 1M$ then

Formula:

Please Login or Register  to view this content.

and plot them on primary (left) axis. But use whole column, not just limited to where large companies data is but also 0s - for small companies
3) for small companies series use

Formula:

Please Login or Register  to view this content.

and plot them on secondary (right) axis. And again - use whole column, not only small companies data. For large companies column height will be anyway 0 by IF formula - and thus not visible.

Further formatting (colors, titles, axis titles and fontsize, etc.) - as needed.


PS. Free advice - one of my standard tricks for presenting data with secondary and primary axis is by using bicolor graph. and graph points, columns, whatever for secondary axis is the same color (may be different hue) as color used for numbers on secondary axis (usually it is worth using bold font for that axis). It keeps reader focused on appropriate axis.

PS2. Your file opens on my computer in standard (for Europe) way. But if you have rigth-to-left orientation of workbook - probably you shall read above comments opposite (leftmost instead of righmost, etc.)

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.