#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"