With MSChart1
.Backdrop.Fill.Style = VtFillStyleBrush
.ColumnCount = 1
.RowCount = UBound(Y, 1) + 1
.Row = 1
For I = 1 To .RowCount
.Row = I
.RowLabel = Format(Y(I - 1, 0), "mm/dd/yy")
Next I
.Backdrop.Fill.Style = VtFillStyleBrush
.Column = 1
.Plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.LocationType = VtChLabelLocationTypeOutside
.Plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.ValueFormat = "#0.00"
.Plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.Custom = True
.Plot.SubPlotLabelPosition = VtChSubPlotLabelLocationTypeAbove
For I = 1 To .RowCount
.Row = I
.Data = Y(I - 1, 1)
Call .Plot.SeriesCollection(1).DataPoints(-1).DataPointLabel.ResetCustomLabel
Next I
End With