See the Chart Height/ Width values in cells

[Frankroger]

Is there a way to see the chart height and width of the chart area/plot area in cells on the spreadsheet?

So that I can see these values from the cells on the spreadsheet, rather than having to open the formatting option box of the chart?

If the chart height and width changes, then the cell would update to show these values.

This code below lets me change the chart height via a cell value, but I'm wanting to do the reverse of this and just see what the chart height/width values are from cells on the sheet, rather than be able to change it.

Also does the plot area even have such options of height and width?
As their is no options to change the proportions of the plot area within the formatting box, so I presume it's linked in some way to the size of the chart area.

Any help would be greatly appreciated!


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

 

[Frankroger]

Ahh I've figured part of it now, the only problem is that the cell doesn't update itself automatically when I resize the chart, but have to manually click on the cell for it to update.

Is there a vba code to force the recalculation of a cell if there has been a change to the height or width of a given chart?


Function Chart Height()

ChartHeight = Activesheet.ChartObjects("Chart 1").Height

End Function

Then entering =ChartHeight() into cell as formula