| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting x Draw (Circle) | Excel Worksheet Functions | |||
| draw a circle & get cell's contents on top? | Excel Discussion (Misc queries) | |||
| Draw a circle to select a desired collection | Excel Programming | |||
| How to Draw an arc which is 1/4 of a circle? | Charts and Charting in Excel | |||
| How to Draw an Arc which is 1/4 of a circle? | Excel Programming | |||
Hybrid Mode
