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

[abiram01]

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]

Thats correct. The minimum and maximum values always change for the chart. So the major and minor uint also should change accordingly.

So is there any method to determeine.


Regards,
Abhiram