Draw a circle to select a desired collection
 

Hi

I have a (x,y)-chart with plots of my customers 'scores', and I want to
make a query of specific customers by drawing a circle that contains
them (in the chart).

Does anyone have any idea how I should do this, or has anyone done
something like that before? I have thought of maybe doing this in a
userform, but I'll consider any other suggestion.

Have a nice one! :)
Eimund

Draw a circle to select a desired collection
 

Hi,

This might be of use. You may need to add a dummy series that is just
the points you wish to encircle if your current data is based on
multiple customers.
http://www.andypope.info/charts/convexhull.htm

Cheers
Andy

eimund wrote:
Hi

I have a (x,y)-chart with plots of my customers 'scores', and I want to
make a query of specific customers by drawing a circle that contains
them (in the chart).

Does anyone have any idea how I should do this, or has anyone done
something like that before? I have thought of maybe doing this in a
userform, but I'll consider any other suggestion.

Have a nice one! :)
Eimund


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Draw a circle to select a desired collection
 

Hi Andy!

Thanks for your answer. It helps me with some of it - however, what I
want to do, is to use the mouse to encircle the cluster of points that
I want to study closer. Is there a way to do this? I might have to
convert my chart into e.g. a picture or something to be able to
encircle...

Any suggestions?

Eimund


Andy Pope skrev:
Hi,

This might be of use. You may need to add a dummy series that is just
the points you wish to encircle if your current data is based on
multiple customers.
http://www.andypope.info/charts/convexhull.htm

Cheers
Andy

eimund wrote:
Hi

I have a (x,y)-chart with plots of my customers 'scores', and I want to
make a query of specific customers by drawing a circle that contains
them (in the chart).

Does anyone have any idea how I should do this, or has anyone done
something like that before? I have thought of maybe doing this in a
userform, but I'll consider any other suggestion.

Have a nice one! :)
Eimund


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Draw a circle to select a desired collection
 

Have a look at this article on interacting with charts.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

eimund wrote:
Hi Andy!

Thanks for your answer. It helps me with some of it - however, what I
want to do, is to use the mouse to encircle the cluster of points that
I want to study closer. Is there a way to do this? I might have to
convert my chart into e.g. a picture or something to be able to
encircle...

Any suggestions?

Eimund


Andy Pope skrev:

Hi,

This might be of use. You may need to add a dummy series that is just
the points you wish to encircle if your current data is based on
multiple customers.
http://www.andypope.info/charts/convexhull.htm

Cheers
Andy

eimund wrote:

Hi

I have a (x,y)-chart with plots of my customers 'scores', and I want to
make a query of specific customers by drawing a circle that contains
them (in the chart).

Does anyone have any idea how I should do this, or has anyone done
something like that before? I have thought of maybe doing this in a
userform, but I'll consider any other suggestion.

Have a nice one! :)
Eimund


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Draw a circle to select a desired collection
 

Hi again!

This wa really helpful to me. Thanks for all your help.
Have a nice day!

Eimund


Andy Pope skrev:
Have a look at this article on interacting with charts.
http://www.computorcompanion.com/LPMArticle.asp?ID=221

eimund wrote:
Hi Andy!

Thanks for your answer. It helps me with some of it - however, what I
want to do, is to use the mouse to encircle the cluster of points that
I want to study closer. Is there a way to do this? I might have to
convert my chart into e.g. a picture or something to be able to
encircle...

Any suggestions?

Eimund


Andy Pope skrev:

Hi,

This might be of use. You may need to add a dummy series that is just
the points you wish to encircle if your current data is based on
multiple customers.
http://www.andypope.info/charts/convexhull.htm

Cheers
Andy

eimund wrote:

Hi

I have a (x,y)-chart with plots of my customers 'scores', and I want to
make a query of specific customers by drawing a circle that contains
them (in the chart).

Does anyone have any idea how I should do this, or has anyone done
something like that before? I have thought of maybe doing this in a
userform, but I'll consider any other suggestion.

Have a nice one! :)
Eimund


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info