Thread: 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

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
>
>

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" <BRRamachandran@discussions.microsoft.com> wrote in
message news:DF78CACA-309B-4178-B94C-D9D90A88F1F0@microsoft.com...
> 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
>>
>>