Re: Reverse the Y-Axis

[User (Legacy)]

Hi all,

I figured it out.  It was not that bad after all.  All that is needed is to

set the scale unit of the axis to -1 as given below:

.Axis(AXIS_Y).ScaleUnit = -1

Thanks for all the help.

Rog

"SteveT" <stephent@compassadv.com> wrote in message

news:p698BeHYAHA.1800@sfxserver.softwarefx.com...

Keeping the X axis at the bottom is the challenge.  Possibly a little

twisted coding to plot your values Max-Value and

replace the Y axis labels with your own in decending order:

   objChart.Axis(AXIS_Y).Label(3) = "48"

   objChart.Axis(AXIS_Y).Label(6) = "45"

   objChart.Axis(AXIS_Y).Label(9) = "42"

   etc.....

Steve

<Roger> wrote in message news:I54NHHHYAHA.1444@sfxserver.softwarefx.com...

> Hi,

>

> Is it possible to reverse the Y-axis - having the highest Y value at the

> bottom and zero at the top, with X axis meeting the Yaxis at the highest

> value ?

>

> Regards,

>

> Rog

>

>