To automate the values for major and minor unit for a chart using VBA

[Killian]

Hi Abhiram,

I assume you're talking about a MSGraph chart...
Assuming "objChart" is your chart object, you can get to the axis properties like this[VBA]With objChart.Axes(xlValue, xlPrimary)
.MajorUnit = 25
.MinorUnit = 5
End With[/VBA]