Line pointers and grid lines in ActiveX chart are mismatched
Posted: Wed Dec 21, 2005 9:54 pm
We are using the ActiveX control to plot time-series data using the scline type pen. The bottom axis is a datetime field and the left axis is numeric. We want to use a bottom label style of Value or Text (i.e., .Axis.Bottom.Labels.Style = talValue) so that we can format the datetime field to display date & time in 2 lines. But, after we zoom in a 2 - 4 times we notice that the line pointers no longer align with the correct vertical grid line.
i.e, after we zoom in a couple of times we notice that the pointer for a value at, let's say 12/18/2005 11:05:00 AM, appears BETWEEN the gridlines for 11:00:00 AM and 11:00:05 AM, when it should lie on the 11:00:05 grid line.
If we set the label style to Auto then this behavior goes away, but then the date format is wrong and we can't modify it without changing the regional settings for the PC (and it still doesn't display 'cleanly')
i.e, after we zoom in a couple of times we notice that the pointer for a value at, let's say 12/18/2005 11:05:00 AM, appears BETWEEN the gridlines for 11:00:00 AM and 11:00:05 AM, when it should lie on the 11:00:05 grid line.
If we set the label style to Auto then this behavior goes away, but then the date format is wrong and we can't modify it without changing the regional settings for the PC (and it still doesn't display 'cleanly')