 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2005How 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/jpg/jpg-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 > Hi > [quoted text clipped - 3 lines] > I mean that my chart will look like this when I run the VBA procedure. > http://phpaw.com/myscrpit/milt-up/jpg/jpg-1125313279.jpg  SignatureAndy 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 > Hi > [quoted text clipped - 3 lines] > I mean that my chart will look like this when I run the VBA procedure. > http://phpaw.com/myscrpit/milt-up/jpg/jpg-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 > Hi > [quoted text clipped - 3 lines] > I mean that my chart will look like this when I run the VBA procedure. > http://phpaw.com/myscrpit/milt-up/jpg/jpg-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 > Sorry, my spacing did not work properly: > [quoted text clipped - 20 lines] > > I mean that my chart will look like this when I run the VBA procedure. > > http://phpaw.com/myscrpit/milt-up/jpg/jpg-1125313279.jpg Hi Mike please send me your example > 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: [quoted text clipped - 29 lines] > > > I mean that my chart will look like this when I run the VBA procedure. > > > http://phpaw.com/myscrpit/milt-up/jpg/jpg-1125313279.jpg I can send you the example XLS file; what e-mail address should I use? Mike > Hi Mike > please send me your example [quoted text clipped - 32 lines] > > > > I mean that my chart will look like this when I run the VBA procedure. > > > > http://phpaw.com/myscrpit/milt-up/jpg/jpg-1125313279.jpg This is my email alimarhoon@hotmail.com thanx > I can send you the example XLS file; what e-mail address should I use? > Mike [quoted text clipped - 35 lines] > > > > > I mean that my chart will look like this when I run the VBA procedure. > > > > > http://phpaw.com/myscrpit/milt-up/jpg/jpg-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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.