Change Chart Height

**scorpio0077** · 07-18-2009, 01:45 PM

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.

Thanks

**romperstomper** · 07-18-2009, 05:57 PM

Do you mean the height of the chart area or of the chartobject? If it's the latter, then a loop like:

Please Login or Register  to view this content.

for example. Of course, you might want to move them too...

**scorpio0077** · 07-18-2009, 06:25 PM

Hey romperstomper, Thanks for the reply. I did mean the Chart area and not the object.

**scorpio0077** · 07-18-2009, 11:56 PM

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!!