Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |