I'm trying to set the X-Axis scale of a chart to set based on the greatest date/time in a column, but am not having good luck. Here's what I have:
'X-Axis
With ActiveChart.Axes(xlCategory)
.Select
.MinimumScaleIsAuto = True
.MaximumScale = DateValue(DateAdd("e", 1, dtDate))
End With
Sample date & time entry:
6/28/2007 9:22:18 AM
The entries are in the E column
Thanks
6/28/2007 9:22
6/28/2007 9:22
6/28/2007 9:22