Excel categories in reverse order doesn work on secondary axis
Hello,
I have got chart with few data on main axis, and one data on secondary axis (red bars on chart).
I want to be both presented in reverse order, but when I set this option, only data from main axis became reversed, and bars on second axis stays where they were.
Please look at attached file and try to turn on reverse order.
How can I change that?
Best Regards
You need to add a the secondary vertical axis so you can reverse the order of that axis as well as the order of the primary one.
Andy thank you for reply.
If I'm not wrong, I have got properly set secondary axix.
Please look at screenshot.
That just illustrates you have set the series to use the secondary axis.
You need to enable the secondary vertical axis. The you can format it in the same way as you formatted the primary vertical axis.
With the chart selected use the + charm, top right of chart, to select axis > Secondary Vertical. You can then apply the relevant formatting to the axis
Oh. I see. Now its workingThank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks