[SOLVED] Change Chart Height

scorpio0077 · #1 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 · #2 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:

Code:

Dim objChtObj as ChartObject
For each objChtObj in Activesheet.chartobjects
   objChtObj.Height = Range("A1").Value
Next objChtObj

scorpio0077 · #3 07-18-2009, 06:25 PM

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

scorpio0077 · #4 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!!

Andy Pope · #5 07-19-2009, 07:42 AM

See here
http://peltiertech.com/Excel/Charts/...nkToSheet.html

scorpio0077 · #6 07-19-2009, 03:32 PM

Thanks Andy!!

Welcome to the Excel Forum

Forum Statistics