|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 2nd, 2009, 04:23 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Bubble Chart best fit Scatter plot
I need to create a scatter plot that will have an oval shape bubble that only
circles the top 75th percentile date ponts. I currently have a scatter plot with data points and then I use an excel object (oval) and size it manually over the chart to fit the top 75th percentile data points. Is there a functions or VBA code I can use to create this best fit oval automaticaly or some type of trick I can use in excel? Thank you 
|
|
#2
October 2nd, 2009, 11:14 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bubble Chart best fit Scatter plot
Hi Tedasu,
Have a look at Fernando Cinquegrani's site http://www.prodomosua.eu/ppage02.html Ed Ferrero www.edferrero.com
|
|
#3
October 2nd, 2009, 11:38 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bubble Chart best fit Scatter plot
I don't see what I'm looking for on this site, am I missing it? Thank you
for your help. "Ed Ferrero" wrote: Hi Tedasu, Have a look at Fernando Cinquegrani's site http://www.prodomosua.eu/ppage02.html Ed Ferrero www.edferrero.com
|
|
#4
October 3rd, 2009, 11:22 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Bubble Chart best fit Scatter plot
Plot the top 75th percentile points as a 2nd series. Now, you can
paste your custom oval for that entire series in one step. The net result will look like 1 series with some data points as ovals and the others as regular markers. On Fri, 2 Oct 2009 08:23:01 -0700, Tedasu wrote: I need to create a scatter plot that will have an oval shape bubble that only circles the top 75th percentile date ponts. I currently have a scatter plot with data points and then I use an excel object (oval) and size it manually over the chart to fit the top 75th percentile data points. Is there a functions or VBA code I can use to create this best fit oval automaticaly or some type of trick I can use in excel? Thank you Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
