Change Chart Height

[scorpio0077]

How do I write a short piece of code that defines the specific height that I want to assign to a chart in Excel 2007?

I have multiple charts on a sheet and I want to update the vertical heights of the charts depending on the value inputted to a cell in the sheet.

What I am looking for is a way to change the Axis Option > Maximum Height across multiple charts, namely

Chart Tools > Format > Under Current Selection, choose Vertical (value) axis > Format Selection > Axis Option > Maximum Height.

I would like to enter the Maximum Height in a cell and the Maximum Value has to change accordingly.

Thanks!!