Re: X-Axis Date Labels

[User (Legacy)]

Thanks Frank for the reply. Doing what you suggest gives me the labels I

want, however that means I have to start the graph at the begining of the

month for this to work which, creates a sort of dead space on the left of

the graph. For instance if I want to plot last 3 months from today (26 Oct

2000 to 26 Jan 2001) I have to start x-axis from 1 Oct 2000.

       ChartFX1.Axis(AXIS_X).Min = CDate("01-10-2000")

I need the x-axis to start from 26 Oct  but the first label to be on 1 Nov.

So ideally the FirstLabel property should take a CDate value when x-axis is

datetime.

        ChartFX1.Axis(AXIS_X).FirstLabel = CDate("01-11-2000")

If you know of any workarounds please let me know.

Also I found that if I tried to format the labels they moved!

        ChartFX1.Axis(AXIS_X).Format = "Xdd/MMM"

gave me labels on 1 Oct, 31 Nov, 30 Dec, 1 Jan. So instead of using the

Format property I had to use the GetAxisLabel event to do this.

Regards.

Pierre Jamali

"Franicisco Padron" <frankp@softwarefx.com> wrote in message

news:95qn3ohhAHA.3064@sfxserver.softwarefx.com...

> You can set the X-Axis min to indicate where the scale starts (at an

> specific date), then, set the LabelValue property (x-axis) to the number

of

> days each point represents (1 would be taken by default), for instance if

> you have one point every week, set the LabelValue to 7.

>

> Frank

> SFX