Hi,
I've got a macro that creates a panel of small charts. The small charts are nice, however, the date axis causes the chart area to get squished. Currently, the date format is the default that the chart creates, 3/10/2012 is an example.
I am thinking that either just 3/12 or or 3/10/12 would work better. The chart formatting section of the code is:
Does anyone know how to add the date format that I desire to my code?
Thanks,
Art
I've got a macro that creates a panel of small charts. The small charts are nice, however, the date axis causes the chart area to get squished. Currently, the date format is the default that the chart creates, 3/10/2012 is an example.
I am thinking that either just 3/12 or or 3/10/12 would work better. The chart formatting section of the code is:
Code:
With ActiveChart
.Legend.Delete
.Axes(xlCategory).TickLabels.AutoScaleFont = False
With .Axes(xlCategory).TickLabels.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 8
End With
.Axes(xlValue).TickLabels.AutoScaleFont = False
With .Axes(xlValue).TickLabels.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 8
End With
.ChartTitle.AutoScaleFont = False
With .ChartTitle.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 8
End With
With .SeriesCollection(1).Format.Line
.Weight = xlThin
End With
End With
Does anyone know how to add the date format that I desire to my code?
Thanks,
Art