|
How to draw contours in a chart??
Hi
Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
Hi,
2 ways depending on how much control over the size and spacing you need. First way is to plot a series of points at the same xy location use the circle marker with no backcolor. Alter the size of each marker to get a set of concentric rings. For move control you will need to plot each ring as a series of xy lines where the points are derived from simple trig formula. Have a look at how the outer ring of the gauge chart is plotted. http://www.andypope.info/charts/gauge.htm If you have problems post back. Cheers Andy Ali Baba wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Ali Baba:
This may qualify as a 'kludge' but, you could create your chart as a Bubble chart. Set your bubble series 'Options' to: 'Size represents: Width of bubbles' and 'Scale bubble size to: 220% of default' Then, select each 'Line' series and: 'Chart | Add trendline' (format your trendlines as you would like) X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2 2.0 1.5 4.0 2.0 1.5 3.0 2.0 1.5 2.0 2.0 1.5 1.0 0.0 -1.0 0.0 1.7 4.0 0.0 1.2 2.5 0.0 2.0 1.5 0.0 If you'd like I'd be happy to e-mail an example of this method. Unfortunately, I don't have a website I can post it to. MikeM "Ali Baba" wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
Sorry, my spacing did not work properly:
FOR the following series (plotted by colums): X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2 X: 2.0 Y: 1.5 BUBBLE1: 4.0 X: 2.0 Y: 1.5 BUBBLE2: 3.0 X: 2.0 Y: 1.5 BUBBLE3: 2.0 X: 2.0 Y: 1.5 BUBBLE4: 1.0 X: 0.0 Y: -1.0 'LINE1': 0.0 X: 1.7 Y: 4.0 'LINE1': 0.0 X: 1.2 Y: 2.5 'LINE2': 0.0 X: 2.0 Y: 1.5 'LINE2': 0.0 MikeM "Ali Baba" wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
I have to apologize to anyone reading this (attempted) post:
There is one more thing I need to add to get this method to work: Create your first Bubble series. Once the chart is created, select your chart, and go to 'Chart | Source data | Series' and add your successive bubble series through this form. Then, add the trendlines to the 'fake' line series. MikeM "MikeM" wrote: Sorry, my spacing did not work properly: FOR the following series (plotted by colums): X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2 X: 2.0 Y: 1.5 BUBBLE1: 4.0 X: 2.0 Y: 1.5 BUBBLE2: 3.0 X: 2.0 Y: 1.5 BUBBLE3: 2.0 X: 2.0 Y: 1.5 BUBBLE4: 1.0 X: 0.0 Y: -1.0 'LINE1': 0.0 X: 1.7 Y: 4.0 'LINE1': 0.0 X: 1.2 Y: 2.5 'LINE2': 0.0 X: 2.0 Y: 1.5 'LINE2': 0.0 MikeM "Ali Baba" wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
Hi Mike
please send me your example "MikeM" wrote: I have to apologize to anyone reading this (attempted) post: There is one more thing I need to add to get this method to work: Create your first Bubble series. Once the chart is created, select your chart, and go to 'Chart | Source data | Series' and add your successive bubble series through this form. Then, add the trendlines to the 'fake' line series. MikeM "MikeM" wrote: Sorry, my spacing did not work properly: FOR the following series (plotted by colums): X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2 X: 2.0 Y: 1.5 BUBBLE1: 4.0 X: 2.0 Y: 1.5 BUBBLE2: 3.0 X: 2.0 Y: 1.5 BUBBLE3: 2.0 X: 2.0 Y: 1.5 BUBBLE4: 1.0 X: 0.0 Y: -1.0 'LINE1': 0.0 X: 1.7 Y: 4.0 'LINE1': 0.0 X: 1.2 Y: 2.5 'LINE2': 0.0 X: 2.0 Y: 1.5 'LINE2': 0.0 MikeM "Ali Baba" wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
I prefer something like when you click on a point this will show the circles
Or you click on a command button and specify the coordinates |
I can send you the example XLS file; what e-mail address should I use?
Mike "Ali Baba" wrote: Hi Mike please send me your example "MikeM" wrote: I have to apologize to anyone reading this (attempted) post: There is one more thing I need to add to get this method to work: Create your first Bubble series. Once the chart is created, select your chart, and go to 'Chart | Source data | Series' and add your successive bubble series through this form. Then, add the trendlines to the 'fake' line series. MikeM "MikeM" wrote: Sorry, my spacing did not work properly: FOR the following series (plotted by colums): X Y BUBBLE1 BUBBLE2 BUBBLE3 BUBBLE4 €˜LINE1 €˜LINE2 X: 2.0 Y: 1.5 BUBBLE1: 4.0 X: 2.0 Y: 1.5 BUBBLE2: 3.0 X: 2.0 Y: 1.5 BUBBLE3: 2.0 X: 2.0 Y: 1.5 BUBBLE4: 1.0 X: 0.0 Y: -1.0 'LINE1': 0.0 X: 1.7 Y: 4.0 'LINE1': 0.0 X: 1.2 Y: 2.5 'LINE2': 0.0 X: 2.0 Y: 1.5 'LINE2': 0.0 MikeM "Ali Baba" wrote: Hi Is it possible to draw a number of equally spaced circles (say 5) around a point in a chart?? I mean that my chart will look like this when I run the VBA procedure. http://phpaw.com/myscrpit/milt-up/jp...1125313279.jpg |
| All times are GMT +1. The time now is 02:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com