Re: Problems labelling and scaling x- and y-axes

[User (Legacy)]

Bernd,

In your csv I assumed semicolon was equal to comma and comma was equal  to

decimal (dot)  Ok?

So last line of data was:

23,11,0.06,178

The ChartFX.gif was before adding _GetAxisLabel, ChartFXTip.gif was after

_GetAxisLabel and adding your tipmask.  ChartFXTip.bmp is "inside" the zip,

the Tip Text did not compress into gif well.

Do these charts look like what you want?

I have always loaded the data first then manipulated the chart object.

    'push recordset to DataProvider

   CfxData.ResultSet = rs

   'Tell it what to expect

   ChartFX1.DataType(0) = CDT_XVALUE

   ChartFX1.DataType(1) = CDT_VALUE

   ChartFX1.DataType(2) = CDT_NOTUSED

   ChartFX1.DataType(3) = CDT_NOTUSED

   'feed the chart

   ChartFX1.GetExternalData CfxData

    With cfx

         .Gallery = BAR

         .Chart3D = True

        ...etc

Steve

"Bernd Hoffmann" <Bernd.Hoffmann@insocam.de> wrote in message

news:3A1E2641.5D05339C@insocam.de...

> SteveT wrote:

> >

> > Bernd,

> >

> > I'd be happy to look further, would you send me a csv file with your

values.

> >

> > Steve

> >

> >

>

>

> Steve,

>

> thanks a lot for your offer to help.

>

> Attached please find the csv-file.

>

> Col1: x-values

> Col2: y-values

> Col3: percentage (not used in chart, only in TipMask)

> Col4: sum of y-values (not used in chart, only in TipMask)

>

> Here the complete code used for the creation of the chart.

> MyRs contains the data of the csv-file.

>

> Private Function InitChart(MyRs As ADOR.Recordset) As Boolean

>

>     Dim CfxData As New CfxDataAdo

>

>     CfxData.ResultSet = MyRs

>     With cfx

>         .Gallery = BAR

>         .Chart3D = True

>         .Title(CHART_TOPTIT) = "Ereignissaufkommen (