Drawing a circle on a chart

You can calculate the circle plot based on a know center X,Y and radius.

You need to provide more information about how the center points should be determined. Perhaps then somebody can construct a formula or more likely vba code.