View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colby Colby is offline
external usenet poster
 
Posts: 10
Default Set Circle Size from cell data?

I'd like to have a series of circles re-size automatically when the values in
certain cells change.

To do this manually, I would right-click a circle, select Format
AutoShape.../Size and fill in the values for Height and Width, and then
repeat for each circle in the set. Is there a way to set the Height and Width
values of the circles automatically when the cell data changes?

Thanks for any ideas on this.