I have excel line chart and a vertical scrollbar connected with it. Right now it is working fine. =.> scrolling up decrease the display range on chart (min & max values). And scrolling down increases the chart display range on chart (min & max values).
But sometime I get data and we want to display inversely and want: if scroll up then should increase the display range on chart (min & max values) and scrolling down decreases the chart display range (min & max values).
If I uncheck the option: VALUES IN REVERS ORDER (Format chart axis) then it reverse the values on chart (this part is right) but how to invert scrollbar properties I AM STUCK HERE (scroll should set to go down & decrease the value and scroll should to go up and increase value). Only option I can think is physically rotate the scrollbar at 360°. This option will not work because we get data and need to switch the option. I spent enough time and burn my mind. I need expert help please.
Attach I sample file. I can provide more details if needs.
![Pic1.PNG Pic1.PNG](https://chandoo.org/forum/data/attachments/87/87196-7b61585c3f287af482165db94c13e9b6.jpg)
![Pic2.PNG Pic2.PNG](https://chandoo.org/forum/data/attachments/87/87197-35808d87827485aed98b28e1fa8d55ad.jpg)
But sometime I get data and we want to display inversely and want: if scroll up then should increase the display range on chart (min & max values) and scrolling down decreases the chart display range (min & max values).
If I uncheck the option: VALUES IN REVERS ORDER (Format chart axis) then it reverse the values on chart (this part is right) but how to invert scrollbar properties I AM STUCK HERE (scroll should set to go down & decrease the value and scroll should to go up and increase value). Only option I can think is physically rotate the scrollbar at 360°. This option will not work because we get data and need to switch the option. I spent enough time and burn my mind. I need expert help please.
Attach I sample file. I can provide more details if needs.
![Pic1.PNG Pic1.PNG](https://chandoo.org/forum/data/attachments/87/87196-7b61585c3f287af482165db94c13e9b6.jpg)
![Pic2.PNG Pic2.PNG](https://chandoo.org/forum/data/attachments/87/87197-35808d87827485aed98b28e1fa8d55ad.jpg)