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

[abiram01]

Ahh... I understand now, you want the min and max values from the data, then set the Axis range...
Is there any reason why you can't set MinimumScaleIsAuto/MaximumScaleIsAuto to True?
Other wise, where do you get the data for the chart? Can you capture the min and max at that stage?

Hi Killian,

The am trying to get the data from the chart data sheet. I will try to set using MinimumScaleIsAuto/MaximumScaleIsAuto.

Can you please explain me how Maximum/Minimum SclaseIsAuto calcutlates the value

Thanks & Regards,
Abhiram.