Jump to content
Software FX Community

zero line graph problem


User (Legacy)
 Share

Recommended Posts

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

Link to comment
Share on other sites

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

>

>

>

>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...