Help: Floating Stacked charts problem

[User (Legacy)]

I still can't resolve the following problem: The problem seems to occur when

the Yfrom and yvalue are different signs

-----------------

Hi

Using your excellent previous suggestions I create floating stacked charts,

using YFrom and Yvalue. The problem is if the stacked values start below

zero.

See the code below. It produces the attached chart. (The data is just

duplicated). The problem is the second series values seems to get assigned

again to the third series, producing an error on the high side. The third

series should end at -900, below the y axis.

Any clues to what I'm doing wrong or is it a bug?

Many thanks

Paul

---------------------------------------------------------

Option Explicit

Private Sub Form_Load()

    Dim dblSeries1Cum           As Double

    Dim dblSeries2Cum           As Double

    dblSeries1Cum = 0

    dblSeries2Cum = 0

    With ChartFX1

        .Chart3D = False

            .ClearData CD_DATA

        '.Cluster = True

        With .Axis(AXIS_Y)

            .ResetScale

            .ForceZero = False

        End With

        .OpenDataEx COD_VALUES, 6, 1

        .OpenDataEx COD_INIVALUES, 6, 1

        .Series(0).YFrom(0) = -3000

        .Series(0).Yvalue(0) = -2600

        .Series(1).YFrom(0) = -2600

        .Series(1).Yvalue(0) = 1600

        .Series(2).YFrom(0) = -1000

        .Series(2).Yvalue(0) = 100

      '  .Series(0).YFrom(0) = -3000

      '  .Series(0).Yvalue(0) = -2600

      '  dblSeries1Cum = .Series(0).Yvalue(0)

      '  .Series(1).YFrom(0) = dblSeries1Cum

      '  .Series(1).Yvalue(0) = 1600

      '  dblSeries1Cum = dblSeries1Cum + .Series(1).Yvalue(0)

      '  .Series(2).YFrom(0) = dblSeries1Cum

      '  .Series(2).Yvalue(0) = 0 '-300 ' -2191 - (-2609)

        .Series(3).YFrom(0) = -3000

        .Series(3).Yvalue(0) = -2600

        .Series(4).YFrom(0) = -2600

        .Series(4).Yvalue(0) = 1600

        .Series(5).YFrom(0) = -1000

        .Series(5).Yvalue(0) = 100

        .CloseData COD_INIVALUES

        .CloseData COD_VALUES

        .Series(0).Gallery = BAR

        .Series(1).Gallery = BAR

        .Series(1).Stacked = True

        .Series(2).Gallery = BAR

        .Series(2).Stacked = True

        .Series(3).Gallery = BAR

        .Series(3).Stacked = False

        .Series(4).Gallery = BAR

        .Series(4).Stacked = True

        .Series(5).Gallery = BAR

        .Series(5).Stacked = True

        .RecalcScale

        With .Axis(AXIS_Y)

            .Min = -4000

            .Max = 2000

        End With

    End With

End Sub

------------

Thanks

Paul

[Software FX]

Stacked charts handle positive/negative values in a different way than

regular charts.

All negative values are grouped and stacked downward while the positive

values are stacked upward.

YFrom however is taken "AS IS", no accumulation is done.

I don't know what you want to achieve but Chart FX is behaving as it should.

Attached is an image explaining this a little bit.

-- 

FP

Software FX, Inc.

[User (Legacy)]

Thanks for your reply

I want to have three stacked series

One that runs from -3000 to -2600, one from -2600 to -1000, and one

from -1000 to +100. How would I would do this?

thanks very much

Paul

"SoftwareFX Support" <support@softwarefx.com> wrote in message

news:JuGyCfGUDHA.1776@WEBSERVER1...

> Stacked charts handle positive/negative values in a different way than

> regular charts.

>

> All negative values are grouped and stacked downward while the positive

> values are stacked upward.

>

> YFrom however is taken "AS IS", no accumulation is done.

>

> I don't know what you want to achieve but Chart FX is behaving as it

should.

>

> Attached is an image explaining this a little bit.

>

>

>

> --

> FP

> Software FX, Inc.

>

>

>