99bobster99
Board Regular
- Joined
- Jul 19, 2004
- Messages
- 95
Hello,
I am using "ChSeries" and "ChChart" within my VBA code and I am having an issue displaying the "X" axis labels. The X axis data points are dates, with a time component. Here is the structure;
"X" Axis label "Y" Axis Data
[2008-02-27 09:49] [1.2650]
[2008-02-27 09:50] [1.2600]
[2008-02-27 09:51] [1.2600]
[2008-02-27 09:52] [1.2601]
[2008-02-27 09:53] [1.2700]
[2008-02-27 09:55] [1.2700]
[2008-02-27 09:57] [1.2601]
[2008-02-27 09:58] [1.2650]
[2008-02-27 09:59] [1.2600]
[2008-02-27 10:01] [1.2600]
I keep getting only the decimal value of the date to the 10 decimal point, being displayed on the "X" axis label. How can I get the date and the corresponding time to be displayed instead?
I am using "ChSeries" and "ChChart" within my VBA code and I am having an issue displaying the "X" axis labels. The X axis data points are dates, with a time component. Here is the structure;
"X" Axis label "Y" Axis Data
[2008-02-27 09:49] [1.2650]
[2008-02-27 09:50] [1.2600]
[2008-02-27 09:51] [1.2600]
[2008-02-27 09:52] [1.2601]
[2008-02-27 09:53] [1.2700]
[2008-02-27 09:55] [1.2700]
[2008-02-27 09:57] [1.2601]
[2008-02-27 09:58] [1.2650]
[2008-02-27 09:59] [1.2600]
[2008-02-27 10:01] [1.2600]
I keep getting only the decimal value of the date to the 10 decimal point, being displayed on the "X" axis label. How can I get the date and the corresponding time to be displayed instead?