Hello Everyone,
I have an excel chart with 2 vertical axis.
There is a problem that the data measured by the second axis appears reversely
I've created an example with world's countries:
Countries by size.xlsx
We can see that the population, which connected with the second axis, appears reversely:
The population of Russia is shown on India and the population of India is shown on Russia ...
How do I fix it?
I'm not entirely sure why it happens this way. In my experience, when you add the secondary vertical axis, Excel often treats the secondary horizontal axis as if it exists, even when the secondary horizontal axis isn't technically there. What I find that I usually need to do is explicitly show the secondary horizontal axis, format the axis so it mirrors the primary horizontal axis, then I can format the secondary horizontal axis to be invisible (no line, no tick mark, no label).
Originally Posted by shg
Thank you very much for the help!
I have tried to do the things you have written but I couldn't find a second horizontal axis.
How do I make to see a second horizontal axis?
See if this tutorial helps you find how to add chart elements in your version: https://www.exceltip.com/excel-chart...-in-excel.html
Thanks a lot!
Hello! You need to cancel the choice of the "Categories in Reverse Order" item for the horizontal axis (See the first photo), and for the secondary axis for the "Labels" parameter, select "High" (See the second photo).
Thank you very much!
If this resolves your question, mark the topic as “Solved”.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks