Size shapes based on a value in a range of cells

[Jacq78]

Hi all

I currently have static sized shapes, however, would like to increase the size depending on a value in a range of cells eg if an issue is high then I'd like the shape to be bigger - this is what I currently have:

If Not WorksheetFunction.IsNumber(ActiveWorkbook.Sheets("Configuration").Range("B25").Value) Then
CheckConfigItems = CheckConfigItems & "The Shape Size Value is Missing from the Configuration Sheet (Cell B25)" & vbCr & vbLf
Else
gShapeSize = ActiveWorkbook.Sheets("Configuration").Range("B25")
End If

How can I update?

Thanks in advance.
Jacq

 

[James006]

Hello,

If you are dealing with Bubble Chart ... see https://peltiertech.com/Excel/Charts/ControlBubbleSizes.html

HTH