Creating A Date Format Using OCW Chart Control

I am using the VBA Chart Control and I have the following instruction;

Me.ChartSpace1.Axes(ChartAxisPositionEnum.chAxisPositionCategory).Numb erFormat = "mm/dd/yy"

The chart is a "chChartTypeLine". the problem is that i cannot change the format of the X-Axis to a Date (mm/dd/yy) format no matter what I try? I keeps wanting to keep it as "General", here is the code;


Private Sub CommandButton1_Click()
Dim ser As ChSeries
Dim cht As ChChart
Dim MinValue As Double
Dim MaxValue As Double

MinValue = Sheet1.Range("D2").Value + 10
MaxValue = Sheet1.Range("A2").Value