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.

Have you looked at a bubble chart - its one of the options on the chart
wizard.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Colby" wrote in message
...
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.

Hi Bernard,

I was hoping for more flexibility in placing the circles, but I may be able
to manipulate a bubble chart to approximate what I want.

If anyone has another idea I'd be glad to hear it, but thanks very much for
this idea, Bernard.

Colby


"Bernard Liengme" wrote:

Have you looked at a bubble chart - its one of the options on the chart
wizard.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Colby" wrote in message
...
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.