Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel |