How to draw contours in a chart??

  • Thread starter Thread starter Guest
  • Start date Start date
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:
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
 
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
 
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
 
Hi Mike
please send me your example

MikeM said:
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
Click to expand...
 
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
 
Back
Top