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.

Set Circle Size from cell data?
 

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.

Set Circle Size from cell data?
 

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.