If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
inverting the y axis
Is there any way that I can plot a line chart of accidents per month, with the y axis going from 20 UP to zero, instead of the normal zero to 20 ? thanks in advance, Bob -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=508937 |
#2
|
|||
|
|||
inverting the y axis
Hi,
Rightclick on the y axis -- "Format Axis" -- select "Scale" Tab and check "Values in reverse order" -- "OK" Regards, B. R. Ramachandran "bob777" wrote: Is there any way that I can plot a line chart of accidents per month, with the y axis going from 20 UP to zero, instead of the normal zero to 20 ? thanks in advance, Bob -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=508937 |
#3
|
|||
|
|||
inverting the y axis
To keep the X axis at the bottom, also check the Category Axis Crosses At
Maximum checkbox. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "B. R.Ramachandran" wrote in message news Hi, Rightclick on the y axis -- "Format Axis" -- select "Scale" Tab and check "Values in reverse order" -- "OK" Regards, B. R. Ramachandran "bob777" wrote: Is there any way that I can plot a line chart of accidents per month, with the y axis going from 20 UP to zero, instead of the normal zero to 20 ? thanks in advance, Bob -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=508937 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
how to add a second x axis with same Y axis value in one plot | Mike | Charts and Charting | 1 | October 19th, 2005 08:42 AM |
can't change how data on 2nd axis is being displayed | Rebekah | Charts and Charting | 1 | May 4th, 2005 02:51 PM |
force graph to axis of choice | Tushar Mehta | Charts and Charting | 3 | February 11th, 2004 04:04 PM |
Two Y axis with different scales for a line chart | vacaut | Charts and Charting | 3 | October 30th, 2003 01:36 PM |