zero line graph problem

[User (Legacy)]

Hi There,

Is anyone out there familiar with the Zero Line feature? I am having

problems with graphing a chart (see below) when the data is all negative

(see I1AbsSW.jpg).  Per Chartfx, this behavior is intended but I can't find

documentation explaining the behavior.  This behavior seems inconsistent

given it only occurs when all data points are negative.  Anyone have any

suggestions on how to get the all negative value charts to generate like

every other data combination (see I1AbsSe.jpg)?

By the way, both these images were generated from the same query, they are

both pulling from the same template and same mdb table.  You can see in one

where it starts at -34000 (see I1AbsSW.jpg) and another starts at 0 (see

I1AbsSe.jpg - what I want!).

The only way I can get ABSSW to work properly is to change one of the

absorption numbers in the SW market to a positive value.  I've provided the

data it's pulling from in the below table.

Thanks,

Melissa

   Market MarketID Year First Half Absorption

      Industrial SE 2002 -84131

      Industrial SE 2002 -4819

      Industrial SE 2002 39472

      Industrial SW 2002 -1663

      Industrial SW 2002 -33947

      Industrial SW 2002 -29417

[Software FX]

You may want do this AFTER you pass the data to the chart (after the

CloseData or GetExternalData call)

if (Chart.Axis(AXIS_Y).Max < 0)

    Chart.Axis(AXIS_Y).Max = 0

You could also do this

if (Chart.Axis(AXIS_Y).Max < 0)

    Chart.Axis(AXIS_Y).Max = -Chart.Axis(AXIS_Y).Min

--

Regards

JC

Software FX Support

"mel lee" <mlee@uproperties.com> wrote in message

news:qzRy2PEKCHA.1280@webserver1.softwarefx.com...

> Hi There,

>

> Is anyone out there familiar with the Zero Line feature? I am having

> problems with graphing a chart (see below) when the data is all negative

> (see I1AbsSW.jpg).  Per Chartfx, this behavior is intended but I can't

find

> documentation explaining the behavior.  This behavior seems inconsistent

> given it only occurs when all data points are negative.  Anyone have any

> suggestions on how to get the all negative value charts to generate like

> every other data combination (see I1AbsSe.jpg)?

>

> By the way, both these images were generated from the same query, they are

> both pulling from the same template and same mdb table.  You can see in

one

> where it starts at -34000 (see I1AbsSW.jpg) and another starts at 0 (see

> I1AbsSe.jpg - what I want!).

>

> The only way I can get ABSSW to work properly is to change one of the

> absorption numbers in the SW market to a positive value.  I've provided

the

> data it's pulling from in the below table.

>

> Thanks,

> Melissa

>

>    Market MarketID Year First Half Absorption

>       Industrial SE 2002 -84131

>       Industrial SE 2002 -4819

>       Industrial SE 2002 39472

>       Industrial SW 2002 -1663

>       Industrial SW 2002 -33947

>       Industrial SW 2002 -29417

>

>

>

>