In a previous post, I received excellent feedback on some calculations for "circles". See URL below for additional details:
As a follow-on question, I now would like to dynamically "resize" the sizes of 2 circles.
Please see attached XLS with an example. For this example XLS, I'm only using two sizes for the inner and outer circle (see drop-down values in cell B1 and B2.
Also, as indicated in notes section of this XLS, I must ensure that the inner circle will always be centered within the outer circle.
Can this be done in Excel?