change the size of a chart based on a value of a cell - possible?

[bluefish44]

Hi All -

I know that I can change the height of a chart area by going into the formatting chart area/size/and then type in a value for height. I was wondering if this height number could instead be set to a value in a certain cell?

Thanks in advance

 

[Yongle]

With VBA ...

Sub AmendChartHeight()
    ActiveSheet.ChartObjects("Chart 1").Height = Range("A1")
End Sub

Useful link

Resizing and Moving Excel Charts with VBA

Use VBA to resize and reposition your charts

peltiertech.com