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

[User (Legacy)]

Bernd,

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

Steve

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

news:3A1CE822.A250AB3D@insocam.de...

> SteveT wrote:

> >

> > Bernd,

> >

> > I have expanded the axis to view the last label:

> > ChartFX.Axis(Axis_X).Max = ChartName.Axis(Axis_X).Max * 1.1

> >

> > also have used the ShowEnds:

> > ChartFX1.Axis(AXIS_Y).Style = ChartFX1.Axis(AXIS_Y).Style Or AS_SHOWENDS

> >

>

> all this doesn't work. I suggest the problem is that my x-values range

from

> 0 to 23 in the resultset. Also, if I use the AS_SHOWENDS then the last

label

> (24) is shown but the first (0) disappears.

>

> > Turn on your MinorStep as well as MinorTickMark:

> > ChartFX.Axis(AXIS_Y).MinorStep = 1

> > ChartFX.Axis(AXIS_Y).MinorTickMark = TS_INSIDE

> >

>

> I tried everything, it doesn't work. I can't format, label and set ticks

for

> the y-axis.

>

> Even for the x-axis custom labelling doesn't work.

> Nothing happens if I use Chart.Axis(AXIS_X).Label(0) = "xxx" and so on for

> all ticks.

>

> Maybe there are some bugs in the trial version? Or does this feature

depend

> on the type of chart you use? In some cases the online help doesn't seem

to

> be very detailed.

>

>

> Bernd