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

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

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

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