|
Formating a datalabel point and a DATE problem
Please Register to Remove these Ads
I am automating a graph from Access but have a specific excel question.
I have a Point with the ShowCategoryName = True
The CategoryName is a date
On the graph the date appears dd/mm/yyyy eg 01/10/2008 (which is as I expect as I have a regional setting which matches this)
But for this point with this (assuming that mypoints is set to one of the points)
Code:
mypoints.DataLabel.Text
Code:
mypoints.DataLabel.Caption
They produce 10/01/2008 ie mm/dd/yyyy
I imagine the answer is either
I am dreaming?
Access is screwing with the date (would not be the first time)?
or ???????
The second part of datalabels is Alignment. I am trying to get my Datalables to an exact position. However if the text of the datalabel is longer then the left hand start of the label starts more to the left which appears to mean that the text is still centred.
Code:
For Each mypoints In Me![Graph0].SeriesCollection(1).Points
With mypoints.DataLabel
.Font.Size = 9
.HorizontalAlignment = xlLeft
.Left = .Left - 15
.Top = .Top - 115
.Text = labeltext
.Orientation = 75
End With
Next mypoints
Last edited by darbid; 07-23-2009 at 05:05 PM.
|