ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y-axis help (https://www.excelbanter.com/charts-charting-excel/156045-y-axis-help.html)

Regivicious

Y-axis help
 
i have the numbers on my chart set like this.....

1
2
3
4
5
6
7
0 1 2 3 4

but i want to change it to this.......

7
6
5
4
3
2
1
0 1 2 3 4


how do i flip-flop the y-axis this way. (I need to do this for good reason!)
Please help!

Jon Peltier

Y-axis help
 
Double click on the axis, and on the Scale tab, check the Values (or
Categories if it's really the X axis, as in a horizontal bar chart) in
reverse order checkbox. You may also need to check the Axis crosses at
maximum checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Regivicious" wrote in message
...
i have the numbers on my chart set like this.....

1
2
3
4
5
6
7
0 1 2 3 4

but i want to change it to this.......

7
6
5
4
3
2
1
0 1 2 3 4


how do i flip-flop the y-axis this way. (I need to do this for good
reason!)
Please help!





All times are GMT +1. The time now is 11:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com